Recent content by dave_m

Can you store the selected date in a field somewhere on the calendar form, have the other form's query data source use a parameter that looks up the value of that field, and manually call .Requery on the second form when a date is selected?

Yes, it will lock. With those parameters you will get a slightly different error (code 3197).

Yes, you will get runtime error 3218 "Could not update; currently locked." Can you do your user interaction outside of the transaction?