469,579 Members | 1,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

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 865
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
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.