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

Want my subform info to autopopulate...

P: n/a
I have a main form with customer names & addresses, and a subform that
I want to have the following: I wish to pull up an equipment name with
a combo box (from my "equipment" table); then have the unit price and
a monthly maximum charge auto-populate in the subform (both values are
in the "equipment" table as well). Why am I having such a tough time
with this? Have tried to create a form/subform with both the wizard
and the toolbox/subform tool. Not having any luck. Suggestions?
Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You might want to create a query on the fly and use the following:

Air Code

Field1 = querycombo.column(0)
Field2 = querycombo.column(1)
Field3 = querycombo.column(2)

etc etc

Rename the fields names to the textboxes you wish to auto populate. Rename the
combox to the name of your combobox and use the code in the afterupdate.

HTH

Michael
Nov 12 '05 #2

P: n/a
Fork_In_Road wrote:
I have a main form with customer names & addresses, and a subform that
I want to have the following: I wish to pull up an equipment name with
a combo box (from my "equipment" table); then have the unit price and
a monthly maximum charge auto-populate in the subform (both values are
in the "equipment" table as well). Why am I having such a tough time
with this? Have tried to create a form/subform with both the wizard
and the toolbox/subform tool. Not having any luck. Suggestions?
Thanks in advance.


Besides advice already provided...MF = Main form, SubForm = SF. You
reference a field like this
Forms!MF!SF!ID = ...
Or
Me!SF!ID = ...

To get the recordsource of SF you enter
strSource = Forms!MF!SF.Form.RecordSource

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.