Hello, I have a textbox on a form that I would like to populate with the results of a query. I would like this to happen when a form opens.
If it helps this is my query
SELECT Max([DMR Tracking].[DMR#]+1) AS myDMR
FROM [DMR Tracking];
I'm new to access and have a form to create a new record. This form when loaded does not know the last defalutId of the previous record. I thought that I can get the last record and get the next value to populate the textbox.
Any help is appreciated!