Recent content by Eolfird

There is about 19 different types of product and about 150 products each with there unique model number. I had though of doing what you said but, i thought that i would run into problems when trying to select a product no use going through 150 products. So, how ideally i would like a lookup...

i have several tables for different computer parts processors, motherboards etc, because there are several different types of each. I then have an order form with the fields processors, motherboards etc all setup as lookup columns. The price of the part is included, in the lookup column, and is...

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?

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...

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

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

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)