Inhibit query if count >10

[zapzip]

Hi- Need some ideas.
I have a form with two sub forms populated by queries. The user moves records from the first (by using Yes/No field) to the second. This is working fine but I would like to prevent more than 10 records in the 2nd form.

Any suggestions appreciate.

Change. Remember. Enjoy. Do it often. Dotcom

 

[ProgramError]

you need to keep a record of the number of items being transfered. Create an integer and increment it each time a record is transfer to the second table. But check if it is less than 10 before executing the query

something like
in the form open event

dim counter as integer
counter = 0

in the event you use to move the item

if counter < 10 then
run the query
else
msgbox "The maximum number of records have been added"
end if



Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.