472,125 Members | 1,387 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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

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.
Nov 18 '14 #1
2 907
3,653 Expert Mod 2GB
If your tables and forms are properly created, the quoteID should automatically be associated with the related record on the sub form.
Nov 19 '14 #2
Thank you Twinnyfo. I have managed to sort out the issue
Nov 27 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by prakashwadhwani | last post: by
6 posts views Thread by insirawali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.