473,573 Members | 3,344 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Want my subform info to autopopulate...

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
2 3151
You might want to create a query on the fly and use the following:

Air Code

Field1 = querycombo.colu mn(0)
Field2 = querycombo.colu mn(1)
Field3 = querycombo.colu mn(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
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.For m.RecordSource

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1666
by: jbroome | last post by:
I have a main form which contains information for several subforms which I can link no problem but i also have some other information from another table which i wish to attach to the main form for the subsequent forms to read. i am unable to use this table in a subform as i am not able to carry the other info over. eg. mainform = student...
2
760
by: Fork_In_Road | last post by:
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...
3
1468
by: Eric | last post by:
Hi, I'm just looking into the samples that are delivered withthe Enterprise Localization Framework/Toolkit. I have set it up and it all works fine. But.. now i have a question. I read a post, from a Microsoft employee i belief, and he stated the following: >3) The AutoPopulate feature doesn't work as well as I
20
10796
by: Robert | last post by:
Need some help to stop me going around in circles on this one.... Have a nested subform (subform2) which simulates a continuous form for the record on the parent subform. Subform2 has rows of either an option button plus two text fields or a checkbox plus two text fields Am wanting to save the user entries into an underlying table. Tag...
1
4256
by: Stephen D Cook | last post by:
I have a search form with a query-linked subform. One of the fields in the subform are date fields. Is there a way to autopopulate the DateFilled field when the person enters the field? I need this to be code which is entered into the form, rather than as a property of the field in the table because there is other data which is entered...
1
1658
by: asavu | last post by:
Hello, I'm somewhat new to this, and I definately need some help. I have a db for a small business, and I have a main form, Customer Info, which has a subform Appliance Info, which has a subform Service Call Info... these three forms are linked, and I run into a problem when I try to search through records. I set up a different form where the...
8
1951
by: Christina123 | last post by:
Currently working with Microsoft Office 2000 and whatever version of Access came with that. I am developing a database to track the comings and goings of shared tools. Everything works splendidly except I have printing issues, primarily I have no idea what I am doing. I have a form that contains the date and the info of the person doing...
5
1607
by: blakerrr | last post by:
Hi everyone, I have a form called Master Order with a subform in it called Order Info. The subform has a nested subform in it called Order Details. Master Order cycles through all of the parts in my database. Order Info contains order specific information (order number, employee ordering, date of order, etc. ) and Order Details contains all...
28
2393
by: CatrionnaRain | last post by:
Hi All - I'm using 2002 and consider myself an intermediate Access user but newbie programmer :) I've been tasked with the db project from hell and have been combing through posts for the last week looking for relevant snippets. The problem is that my problem is multi-tiered and although I've seen hints I haven't yet come across anything...
2
1697
by: debson | last post by:
Hi I have a main form in which I have linked subforms on tabs.. My problem is that I have one subform which is linked to a table which has 2 to 6 sessions in one table, we are required to fill out a feedback form for each session. So I have put hidden 6 tabs with subforms on each tab linked back to tbl_feedback..... So far I have it set up...
0
7641
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7957
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8155
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8001
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6338
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5248
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1241
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
976
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.