By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 1,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

enter data into a table

P: n/a
There is a subform embedded into a Main Form...
Subform is standing for entering data into a table...

There is a combobox on the Main Form...
How Combo Box value can be added into table to which we enter data from
subform? I mean, when you enter 10 new items in the subform, combo box
value should take place for a specific column ot that table for every
new 10 item...

Am I clear?

Oct 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
OK, from what you said I think you want to default a value into a text box
in a subform datasheet, based on the currently selected value in a combo box
on the parent form, whenever a new record is inserted into the datasheet.

If this is what you want you'll be pleased to know its very straightforward.
On the subforms "Form_BeforeInsert" event, add code to default a value into
the textbox.
Something like:

txtTextBoxToReceiveDefaultValue = Form_MainForm.cboComboBox.Value

Hope this helps

Iain Bishop
www.ibdesign.com.au
<sa*************@yahoo.comwrote in message
news:11**********************@f16g2000cwb.googlegr oups.com...
There is a subform embedded into a Main Form...
Subform is standing for entering data into a table...

There is a combobox on the Main Form...
How Combo Box value can be added into table to which we enter data from
subform? I mean, when you enter 10 new items in the subform, combo box
value should take place for a specific column ot that table for every
new 10 item...

Am I clear?

Oct 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.