COMBO BOX FILTER ON A SUBFORM

  • Thread starter Thread starter Samora
  • Start date Start date
S

Samora

Hello everyone

i have a query with Patients's number and name (Table -
TPatients)

i want to make a form with a subform based on a
combobox(based on that query) , that works as a filter, to
display all the details from another table (This table has
the patient's number that works as the link field).

Everytime i try to do something like that , doesn't work
and i try to work with the Parameter Query and everything
goes OK. But i think this issue MUST be done with a Filter
on a Combobox and not like i am doing, because is much more
flexible.

How can i do it ???

The relationship between those tables are 1 to 1

Could someone help me???

I would apreciate very much...

P.S. Question: Maybe it's a better idea to look up the
details based on the patient's name instead of patient's
number. However i am just storing the number and not the
name as i am used to do.
But, in case you think this is a better idea (Name instead
of number) what should i do?

Best regards to all of you
 
Good evening

DO you mean when i design my query in Design view on the
row of my field Number in Criteria ?

Please tell me something about it

Thanks in advance

Best regards
-----Original Message-----
Use this in query criteria --
[FormName]![SubformName]![ComboboxName]
-----Original Message-----
Hello everyone

i have a query with Patients's number and name (Table -
TPatients)

i want to make a form with a subform based on a
combobox(based on that query) , that works as a filter, to
display all the details from another table (This table has
the patient's number that works as the link field).

Everytime i try to do something like that , doesn't work
and i try to work with the Parameter Query and everything
goes OK. But i think this issue MUST be done with a Filter
on a Combobox and not like i am doing, because is much more
flexible.

How can i do it ???

The relationship between those tables are 1 to 1

Could someone help me???

I would apreciate very much...

P.S. Question: Maybe it's a better idea to look up the
details based on the patient's name instead of patient's
number. However i am just storing the number and not the
name as i am used to do.
But, in case you think this is a better idea (Name instead
of number) what should i do?

Best regards to all of you


.
Click to expand...
.
Click to expand...
 
Please forgive me, but i have another question

1 - the formname you mention is the main form where i have
my combobox, right?

2 - My combobox is bound or unbound?

3 - By entering a number on my combobox i will retrieve all
the information that matches that number on the other
table? (This is what i really want).

Thanks for your kindness

Best regards


-----Original Message-----
Use this in query criteria --
[FormName]![SubformName]![ComboboxName]
-----Original Message-----
Hello everyone

i have a query with Patients's number and name (Table -
TPatients)

i want to make a form with a subform based on a
combobox(based on that query) , that works as a filter, to
display all the details from another table (This table has
the patient's number that works as the link field).

Everytime i try to do something like that , doesn't work
and i try to work with the Parameter Query and everything
goes OK. But i think this issue MUST be done with a Filter
on a Combobox and not like i am doing, because is much more
flexible.

How can i do it ???

The relationship between those tables are 1 to 1

Could someone help me???

I would apreciate very much...

P.S. Question: Maybe it's a better idea to look up the
details based on the patient's name instead of patient's
number. However i am just storing the number and not the
name as i am used to do.
But, in case you think this is a better idea (Name instead
of number) what should i do?

Best regards to all of you


.
Click to expand...
.
Click to expand...
 
On the menu click VIEW, Toolbars, Database. Highlight
your query and click the Design icon on the toolbar- it
looks like a ruler with drawing triangle and a pencil.
-----Original Message-----
Good evening

DO you mean when i design my query in Design view on the
row of my field Number in Criteria ?

Please tell me something about it

Thanks in advance

Best regards
-----Original Message-----
Use this in query criteria --
[FormName]![SubformName]![ComboboxName]
-----Original Message-----
Hello everyone

i have a query with Patients's number and name (Table -
TPatients)

i want to make a form with a subform based on a
combobox(based on that query) , that works as a
Click to expand...
filter,
to
display all the details from another table (This table has
the patient's number that works as the link field).

Everytime i try to do something like that , doesn't work
and i try to work with the Parameter Query and everything
goes OK. But i think this issue MUST be done with a Filter
on a Combobox and not like i am doing, because is much more
flexible.

How can i do it ???

The relationship between those tables are 1 to 1

Could someone help me???

I would apreciate very much...

P.S. Question: Maybe it's a better idea to look up the
details based on the patient's name instead of patient's
number. However i am just storing the number and not the
name as i am used to do.
But, in case you think this is a better idea (Name instead
of number) what should i do?

Best regards to all of you


.
Click to expand...
.
Click to expand...
.
Click to expand...
 
1- Correct 2- Does not matter 3- Correct
-----Original Message-----
Please forgive me, but i have another question

1 - the formname you mention is the main form where i have
my combobox, right?

2 - My combobox is bound or unbound?

3 - By entering a number on my combobox i will retrieve all
the information that matches that number on the other
table? (This is what i really want).

Thanks for your kindness

Best regards


-----Original Message-----
Use this in query criteria --
[FormName]![SubformName]![ComboboxName]
-----Original Message-----
Hello everyone

i have a query with Patients's number and name (Table -
TPatients)

i want to make a form with a subform based on a
combobox(based on that query) , that works as a
Click to expand...
filter,
to
display all the details from another table (This table has
the patient's number that works as the link field).

Everytime i try to do something like that , doesn't work
and i try to work with the Parameter Query and everything
goes OK. But i think this issue MUST be done with a Filter
on a Combobox and not like i am doing, because is much more
flexible.

How can i do it ???

The relationship between those tables are 1 to 1

Could someone help me???

I would apreciate very much...

P.S. Question: Maybe it's a better idea to look up the
details based on the patient's name instead of patient's
number. However i am just storing the number and not the
name as i am used to do.
But, in case you think this is a better idea (Name instead
of number) what should i do?

Best regards to all of you


.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top