i have a DB, and a few tables, there is an autoID wich is the primary key. on my main interface i have a subform that grabs data from a second table. the problem i am having, is getting the subform to pickup the proper Data from the secondary table. in the second table if i enter A "1" in the If field, and then refresh my subform the data will pickup, but instead of this, i want the data to be picked up by the account number instead of auto Id, how can i accomplish this. like if i put the account number(44B77) in cell1 of table 2 and refresh the subform the data is not visible, but if i change the account# to 1, then the proper data shoes?!
Thanks in advance..