Form driven query

[KidKeller]

I have a form, Form_Add_Record, which contains a date(mm/yy) and position field. When the date is filled in and the user tabs to the position field I want to fill in the position with the the next position for that month (i.e.: records for that date + 1).

I know the statement I need:

SELECT COUNT(*) + 1 AS position FROM alldata
WHERE Alldata!date = date

I just don't know how to get it to execute when I want to.

Any suggestions will be gratefully tested.

 

[jedraw]

I think your code will be in the AfterUpdate Event of the Date control on your Form.


You will want set the Position control to the new value.
I don't think you really want the user to Tab to the Date field - for what reason if you have already filled it in?

Good luck.