Thanks Duane,
This is another of my data on remote server and the operations of
'add', 'edit' and 'delete' being handled by ASP pages. Forms are not used.
I can hard code the current rate and change the code when the rate changes.
Robin Chapple.
At 5/08/2012 04:52 AM, you wrote:
>You solution won't work.
>I would use a form to enter new records. In the On Open event of the
>form, use some code to set the Default Value property of a control.
>
>If tServiceRate has only one record, you can try something like:
>
>Me.txtRate.DefaultValue = Dlookup("Rate","tServiceRate")
>
>Duane Hookom
>MS Access MVP
>
>----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: robinski@mymail.net.au
> > Date: Sat, 4 Aug 2012 09:09:03 +1000
> > Subject: [MS_AccessPros] Look up fixed value
> >
> >
> > I have a Projects table that includes a currency field 'Rate'. I need
> > each new entry to use the 'Rate' as recorded in a separate table
> > 'tServiceRate'.
> >
> > I have used this:
> >
> > =[tServiceRate].[Rate]
> >
> > as the default value for 'Rate' in the Projects. Error reports
> > "cannot find field".
> >
> > What have I missed?
> >
> > Many thanks,
> >
> > Robin Chapple.
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Jumat, 03 Agustus 2012
RE: [MS_AccessPros] Look up fixed value
__._,_.___
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar