Given two forms, frmMaster and frmLinked with the obvious relationship.
I have a combo box on frmLinked, it gets its rows from a table, ie
select SystemId, Make + Model from tblSystem
I want to restrict the rows returned based on a field that is only
available on frmMaster. ie
select SystemId, Make + Model from tblSystem where ClientId = <???>
I don't know how to refer to the required field on frmMaster when I am
typing in the .RowSource property of the cbo.
2  1775 
Assuming the control on frmMaster is named MyText, <???> could be
Forms!frmMaster !MyText
HTH
"HateSpam" <Ha******@nospa m.com> wrote in message
news:D4******** ************@fe 2.columbus.rr.c om... Given two forms, frmMaster and frmLinked with the obvious relationship.
I have a combo box on frmLinked, it gets its rows from a table, ie
select SystemId, Make + Model from tblSystem
I want to restrict the rows returned based on a field that is only
available on frmMaster. ie
select SystemId, Make + Model from tblSystem where ClientId = <???>
I don't know how to refer to the required field on frmMaster when I am
typing in the .RowSource property of the cbo. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sean |
last post by:
Greetings all,
I am attempting to make a form that will filter through several tables
that
(I believe) have refretial integrity. I am pulling data from several
tables into the form and i would like to eventually be able to filter
down through the
tables untill i can reach one unique record. I am creating a datbase
to keep track of registered accounts for a stae program. Each
account is registered into the program through a two...
|
by: Megan |
last post by:
Hi everybody-
I inherited a database that somehow uses a bound combo box as a record
selector. Let me give you some background. The form is based on data
from 2 tables. The first table, Person, records info about a person.
The second table, Case, records information about a person's case,
almost like a human resources database.
The primary key of the table, person, is his/ her social security
number. The primary key of the other...
|
by: Lyn |
last post by:
Hi,
Can anyone tell me how the initial value displayed in Combo Box is
determined when a form is opened?
I am loading the dropdown from one field ("CategoryName") of a table, with
"ORDER BY ". The values in the dropdown are loaded in the
correct order, but the initial value is not the first row of the dropdown as
I expected.
The field "CategoryName" is not the primary key for the table -- the PK is
|
by: Les |
last post by:
Good day,
I am new to Access and need a question answered please.
I have a form based on a table (tblQualityEmployees), for some of the
fields it looks up a value in another table (tblGroups).
The tblQualityEmployees consists of the following:
EmployeeID
|
by: fstenoughsnoopy |
last post by:
Ok the complete story. I have a Contact Table, Query and Form, that
are used to input
and store the contact info for customers. They have FirstName, LastName
and Address as the primary key fields to keep out duplicates. I am
trying to put a full name box on the query, that uses the FirstName,
LastName and Middle Initial and puts them together to form a full name.
That I have so far. On my order database(consisting of a master table
with...
| | |
by: pankajm |
last post by:
Hello Friends:
I am trying to populate a subform that has three fields that would pull view only data from a child table. The criteria for this data is to select the three fields where one of them is the value of column 1 of a combo box on the main form. This field is also the master child link between the two tables.
The combo field is SSN. So when I populate SSN in the main form, I would like the SSN to be used as a select statement like...
|
by: virtualgreek |
last post by:
Dear All,
First of all I would like to take the time to thank you all for your efforts and time spent at this wonderful forum. I have found it very helpful with numerous examples available for every level of user.
I am facing a rather weird behaviour with a combo box on a subform (Continuous form).
I have two tables. Order and Order_Details. The master form is based on the Orders tables and the details form (subform) is based on the...
|
by: biganthony via AccessMonster.com |
last post by:
Hi,
I decided to install Office 2003 Service Pack 3 on my home computer to test
(in full knowledge that there may be some issues with it). After installation,
I have noticed that with a small database I wrote for home, the combo boxes
and listboxes no longer display the bound column. For example, on a form I
have a combo box based on a table called 'names'. The two columns in the
combo box are ID and Surname. The combo box and list box...
|
by: whamo |
last post by:
I have the need to populate a field based on the selection in a combo box.
Starting out simple. (2) tables tbl_OSE_Info and tbl_Input;
tbl_OSE_Info has three fields: Key, OSE_Name and OSE_Wt
tbl_Input has three fields: OSE_Job, OSE_Name, OSE_Wt
I have populated tbl_OSE_Info table.
I need to create a form that will store the data in tbl_Input
I have racked my brain so much trying to figure out how to auto populate a field based on a...
|
by: banderson |
last post by:
Hello,
I have a data entry form for a table with information about buildings and am having a problem making a combo box do what I want. I would like to make the combo box show a list of unique bldg mgmt company names and then to open a building management company form to show all records with this name, so the user can find the correct branch location to select. Then, upon closing the building management company form, the active/selected record...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
