I am building a database that has users enter information. Often, the data they enter is dependent on a response from a customer which may not come until several days later. My idea was to use a combo box on a form which, via query, would be populated with only incomplete records and then once selected, the user would press a button to open a form similar to the first and see the original information and be able to add the recently received information.

I have it as far as the query and combo box written, but when I go to the form I would like to launch, only the account number that the user selected from the combo box is populated, the other fields, despite the presence of data in the table, show as empty.

Help please.