Hello everyone,

I am pretty good at the basic database creation although, learning all the time.

I have run in to a problem with a small database I created of members of an organization for which I belong.

I am entering their member number to an unbound form field, (record source is from a table) and then pressing a command button I created that has another form pop up with selected information about that member.

This seems to work OK although what I would like to do next is where I am stuck, I would like to have a command button that would commit the registration information to a report. If the member is not valid I would like to have either another button or just exit that form so that information is not saved to the report.

Here comes the big problem, I would like to be able to save all of the registrations for that specific event to the report sequentially so at the end of the evening I can save and print out a report of all the individuals who were valid and checked in to the event.

I know I am missing a couple steps here, such as creating a query, and using a query as the record source etc..

I have received some advice from others although very complicated to do what seems like something that should be very simple.

Can anyone help push me in the right direction?

Ron

Welcome to Utter Access

for printing reports just for a particular record:

setting report filters


to record the registrations, you will need a field for that information. It can be filled out automatically using

me.controlname = nz(dMAX("[fieldname]","[tablename]")) + 1

Thank you, I will give it a try!

Ron

you're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)