>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