>I have 2 tables, user and rank tables. the user table has a foreign key linked to the rank table. When my users open up the new user form, i need to populate the rank foreign key with the rank they select from a drop down box. How can I do this?
I'm sure someone will come up with a more elegant solution, but I'd put the following in the 'lost focus' event, assuming you want that rank information:
Select
fieldlist from Rank where Rank.fKey = This.Value
or, if Rank_fKey is defined as a variable,
Rank_fKey = This.Value
Translate as necessary
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place