473,385 Members | 1,736 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,385 software developers and data experts.

in subform different query

Hello,
my problem is maybe simple but I not see good solution.

I have one form with subform. Form is made from table with one field
and can
not be added new staff.
Subform is continius form made from query.
I try to see if is possible to made some IF THEN or somethng like this
between form and subform.

If in form is define "staff A" I want that in suboform is open query
number
one with staff connected with form.
If in form is define "staff B" I want that in suboform is open query
number
two with staff connected with form.

So different query in subform. Is this possible?

All suggestion is very welcome

Igor Kramarsich, dipl. ing.

Nov 14 '05 #1
1 1380
ki***@net.hr wrote:
Hello,
my problem is maybe simple but I not see good solution.

I have one form with subform. Form is made from table with one field
and can
not be added new staff.
Subform is continius form made from query.
I try to see if is possible to made some IF THEN or somethng like this
between form and subform.

If in form is define "staff A" I want that in suboform is open query
number
one with staff connected with form.
If in form is define "staff B" I want that in suboform is open query
number
two with staff connected with form.

So different query in subform. Is this possible?

All suggestion is very welcome

Igor Kramarsich, dipl. ing.

See if something like this works
If Me.StaffType = "A" Then
Forms!YourMainFormName!YourSubFormName.Form.Record source = "QueryStaffA"
Else
Forms!YourMainFormName!YourSubFormName.Form.Record source = "QueryStaffB"
ENdif
Nov 14 '05 #2

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

Similar topics

4
by: CSDunn | last post by:
Hello, I have a combo box (Combo7) that needs to call a function during the After Update event of the combo box. The function resides in an Access 2000 ADP Module called MMAnswerData_code. The...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
3
by: Nicolae Fieraru | last post by:
Hi All, I have a problem and I can't figure out how to solve it. My database has three tables: tblCustomers, with CustomerId and CustomerName tblProducts, with ProductId and ProductCode...
9
by: PC Datasheet | last post by:
I'm stuck on something that seems should be easy and I need some help. My main form has an option group with five options. My subform chooses from different lists depending on which option is...
0
by: Igor Kramarsic | last post by:
Hello, my problem is maybe simple but I not see good solution. I have one form with subform. Form is made from table with one field and can not be added new staff. Subform is continius form...
2
by: Axel | last post by:
Hi, a question about something that seems very simple at first glance: is it possible to reference other controls of a subform in a query window without referencing through the parent form? I...
14
by: Kurt | last post by:
I have an unbound main form with an unbound subform. frmProjects fsubProjectList Using combo boxes, the user can select several search criteria on frmProjects and then click a command button....
1
by: lawton | last post by:
Source: this is an access 2003 question My knowledge level: reading books, internet, and trial & error; no formal training I'm trying to get a running sum of what's filtered in a subform which is...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
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...
0
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,...
0
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...

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.