How do you read a record from a query into a form box and then write to a table??

[ConcordMan733]

Hey guys can you give me some help on this?
There's lots of threads on the subject of sequential numbers, i spent most of yesterday and today reading them trying to figure this problem i'm having out but they're all missing information on one thing.

basically I have a table of information relating to a test form, and I want the forms to have sequential Test Numbers. So I made a query that uses dmax to find the highest test Request number so far.
So right now when I go to the form I have in Access to create a new Test Request, I have the dmax value+1 showing up in the Test Request Number Field.
My question is how do I link that field to the table of information so that when I save the form the new test request number shows up in it?

Thanks for your help.

 

[GinaWhipp]

Is this a bound form? (Because that would certainly save alot of queries and/or VBA code to get this done.) If it is not a bound form then why not?