Auto Fill Fields

[Cordell]

Need Help

I currently have a form (Trip Log) that tracks the guests. On the form I
have two field names (Guest 1 and Guest 2. If the Guest is not in the Drop
Down list I have a Command button that take me to a contact form page where I
can add the Guest name. I have a command button that takes me back to the
Guest field and the new Guest name is now in the Drop Down.

My question is: After updating the contact page and reopening the Trip Log I
would like to see the Guest name already in the Guest Field (without using
the Drop Down.)
Is this possible?

Thank you,

Cordell

 

[Jeff Boyce]

Cordell

Take a look at Access HELP for the Not In List event. There should be an
example of the code you'd use to do that.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/