linked forms?

[Eolfird]

i have been trying to get forms to link so that the sub form appears as a button on the main form . But it wont work it says that i need to create a record in the main table first, and i already have. it works when i check sub form but not when i check linked form (using form wizard)

 

[sonny]

Can you post a sample of the db?

 

[Eolfird]

Download the sample database here Here I want to synchronize the records between the 2 forms 'Table1' and 'Table2'

 

[Eolfird]

thanks for that. its now saving the record in the primary form but its always showing customerID 1 (the forms arnt synchronised) any ideas? Thansk again

 

[WayneRyan]

E,

Your maintenance button is just:

DoCmd.OpenForm "Table2"

The data is ALL records in Table2.

You need:

DoCmd.OpenForm "Table2", , , "[CustomerID] = " & Me.CustomerID

Wayne

 

[Eolfird]

ok the code i have put in now filters te records and matches the customer ids. However this doesnt help when i want to add a new record and automatically enter the CustomerID from the first form into the sub form. This works when i use a sub form on the same page but when i link the 2 forms with a button it wont enter the CustomerID in the second form. Any ideas?

thanks again simon

 

[Eolfird]

thanks Pat that works a treat! gonna have to play around a bit to get it to save the first form but should be ok. Does anybody know why the wizard doesnt do all this automatically? is it the wizard or is it me?