Access 2007: form from append query

R

rgaster5

I'm building a tool to create invitation lists from a basic contacts table.
I've created a new invitation table and a basic append query that takes
records from the contacts table and adds them - based no selection criteria -
to the invitation table.

I want to add this function as a form, so the filter is managed by the user,
and then add the form to the switchboard.

But Access won't allow me to create the form.

any solutions?

thanks

Robin
 
J

June7 via AccessMonster.com

First of all, should not be duplicating records. Invitations table should
have a contactID field that would link to the contactID in the contacts table,
and then a field for the eventID. Then there should be an Events table with
fields that describe the event and an eventID field. Why can't you create the
form? What is error message? Even if you decide not to normalize your data
structure, no need to duplicate records. You can build a report based on the
criteria provided, that report would have RecordSource querying the table(s)
with needed data.
 
Top