473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

subforms based on main form field

Hi everybody, new to Bytes, thanks for looking at my problem. I have a main form (Main) with 3 subforms in it (Customer), (Address), (Account). All these are based on queries which prompts the user for the customer ID. How can I get it to only prompt for this information once when opening the main form? Ideally it would be entered once to populate the main form and the subforms would populate based on the Customer ID field on the main form.
Oct 12 '11 #1
1 1259
NeoPa
32,556 Expert Mod 16PB
When setting up a SubForm control there are properties you can view. Some of which control which records are allowed in the SubForm related to the current record in the main form. I suggest you go and have a play with those. Come back if you can't manage to find your way around, though it's pretty straightforward so I doubt we'll see you back on that score.

As far as entering IDs goes, you may want to explore the concept of filtering based on existing lists found in a ComboBox instead. There is a tutorial on this found at Example Filtering on a Form.
Oct 12 '11 #2

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

Similar topics

0
by: Olivier | last post by:
Hi, I have a (newbie)problem with a macro activated in a subform. That's the hierarchy in my form: Main form ----subform1 ----subform2 ----subform3 I have a macro that is called on...
9
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text field called . It gets populated based on what the user selects in a field on the...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
2
jayfrankland
by: jayfrankland | last post by:
Hello: I have a form called ApplicationFees that contains a field value called Project_Id. Within the page I also have an iframe. I need to get or request the Project_Id value from the...
3
by: BASSPU03 | last post by:
My "View All Resources" code is no longer fully suitable for its respective DB form. Now it's not a matter of just opening one form and making it read-only. Now I have a main form with three...
1
by: maciejfr | last post by:
Hello everyone, My problem is updating Subform filter by onchange event in one of main form field I've got following: Me!.Form.Filter = " = "" N "" OR ( = ""T"" AND notanr = " & Me!nrnoty...
1
by: viksha | last post by:
Hi, I need help to get sum of field in subform to main form field I am using Mainform's field (total) default value =Sum(!!) Please help
5
sickenhoofer
by: sickenhoofer | last post by:
I have a form w several subforms. The ultimate goal would be to click on a location, and have the data in the other subforms change to the data specific to that location. For this form, there are...
5
by: mdzeier | last post by:
I need to know how to maxinimze subforms to the size of the main form. I have managed to do the code to maximize the main form, but it does not work on the subforms. The main form contains 6...
0
by: David Wilschek | last post by:
Hello, I am trying to make a high level summary form which has multiple subforms displayed on open in pivot chart view. When i go into form view on the main form i can only manipulate one of the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.