Auto insert associated value on form based on value entered by user.

[RHorton1976]

Hi there,

I have a form in place whereby the user enters data. I want to insert a field on the form which would be automatically generated and displayed based on a date parameter entered by the user beforehand. If the user enters 01/10/2008 in the 'start date' field then I want the associated value to be looked up in a seperate table and reflected on the form as soon as the 'start date' was entered. Is there any way of accomplishing this without using VBA as skills aren't that advanced?

Thanks a lot - your advice is greatly appreciated!

 

[randy700]

Perhaps something like this as the row source?

=DLookUp("fieldname","tablename","datefield = " & textboxname)

Randy

 

[RHorton1976]

Thanks a lot Randy!

I ended up using a subform which works quite well =:0)