Continuous form and append query

[sbaud2003]

Hi Respect Sir

Can I append a table with the values from a continuous Form having records with criteria

 

[theDBguy]

You could try by using the record source of the form and its filter.

 

[sbaud2003]

Sir I have two table Member table and Restaurant table. Now i want to append the records in the Restaurant table from a form having members and a few unbound text boxes which will have the same inputs for all members

 

[Pat Hartman]

For starters, I think you are missing a table in your relationship. You seem to need a junction table. That table would contain the foreign key for the member and the foreign key for the restaurant. In the junction table would also be a date and possibly a dollar amount for the charge.

I'm going to post a link to a many-many relationship that might help clarify your thinking. Look at the Employee form. It shows a subform bound to the junction table where you can pick a class and associate a completed date and grade. In your case, if I understand your description, you would have the Restaurant as the main form and the MemberRestaurant junction table bound to the subform. You will have a combo to select the member and than you can enter the date and a dollar amount.

Many-to-many example

I added a new version on 1/16/23 so choose that one rather than the old one unless you specifically want the old one. The old zip file contains both A97 and AXP versions of the database. It uses venue booking as the example and shows the relationship from both sides. A venue main form with...

www.access-programmers.co.uk