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?