using unique id data field to be stored into a field in a subform

[sabogfaction]

Hi there

I am a novice on microsoft access 2007 VBA and would like to seek advise/help from anyone that knows.

I have two tables...

Main form table (use for my data entry) consisting fields:
- QuoteID (autonumber)
- SalesPerson
- Date
- Description

Subform table (based on a query from another table) which consists the fields below:
- VendorName (child field)
- ProductID
- Description
- Checkbox (Y/N)
- QuoteID

Would like to know how... QuoteID from the main form copy across to the QuoteID field into the subform as and when the checkbox have been ticked?

Your help and input is very much appreciated. Thank you.

[twinnyfo]

If your tables and forms are properly created, the quoteID should automatically be associated with the related record on the sub form.

[sabogfaction]

Thank you Twinnyfo. I have managed to sort out the issue