ACCESS FEED: RE: [MS_AccessPros] Look up fixed value

Jumat, 03 Agustus 2012

RE: [MS_AccessPros] Look up fixed value

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
>
>
>