access coding

[biscuitbandit]

ok microsoft access, i run a query, the query has a popup box when it runs asking "Please enter a name", this is because i put [Please enter a name] in the criteria box, i put in a name and it returns 2 records.
how do i get a message box to say "there are 2 records matching your search string" or something similar. oh im gunna base a form on the query too, so when the form is opened i will get the same prompt from the query. forms have little record selectors displayin how many records there r so there must b sum way of doin it
:rolleyes:

i no its brief but any suggestions wud b appreciated, coz im just about to start smashing the office assistants smug little face in

*sigh*

[gryps]

i don't think u can associate code with query events in access, however u can in a form.

in form design view:
1. Click Events Tab
1. Find on_open event
3. Go to the code builder
4. In on_open sub enter
Msgbox("found " & Me.RecordSet.RecordCount & " records")

hope this helps

[biscuitbandit]

gryps i could kiss you