form query

[ryan.fitzpatrick3]

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

i.e

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form

 

[Golfinray]

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

 

[ryan.fitzpatrick3]

So no query?

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

No subform with table either?

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

Did all the cboxes the way you said, it looks like it's pulling enough
records but I can't get teh continuous sub table to show the records,
at the bottom of access in the left corner it'll say calculating 100
records but the correct records doesn't show on the sub form.

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -

 

[Golfinray]

You should be able to, but 5 is getting up there. Post back if you don't get
it to work.

When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

where do I do this at, in the properties click link it only allows 5.
Do you know what I mean before? Your code queries the information but
it doesn't filter on the subform (table).

You should be able to, but 5 is getting up there. Post back if you don't get
it to work.

When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?

Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo boxto the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.
:
I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.
Company
Plant
item #
item desc
vend #
vend name
buyer ID
In most of the cboxs I have a selection to choose from either through
value or table/query.
Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.
i.e
company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO
Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up whenI
run the query. What should I do? Does this make sense? Thanks a
million.
The subform is linked to the main form- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Beetle]

I would suggest you take a step back here. There are some inherent
problems in the way you are approaching this. You may also have some
table design problems, but that's hard to say without some clarification.

For example, you said you have a form based on a query that has the
following fields;

Company
Plant
item #
item desc
vend #
vend name
buyer ID

Do these fields all come from the same table? Or is this a multi-table query?

If it is the latter, then it may be appropriate. If it is the former, then you
have a table design problem which should be corrected before you spend
a lot of time and effort creating forms. The multiple entities of data that
are described by those field names should not all be in the same table.

Which brings us to the design of your form, which is certainly wrong (at least
if I am reading your posts correctly). According to what you've said so far,
your main form's recordset (table/query) has the above mentioned fields.
Within that main form you have a subform which has the exact same fields
in it's recordset.

If you are trying to set up a form where a user can select as few, or as
many, criteria as they wish to search by, then you are going about it the
wrong way. What you would do (at least one viable approach) is create
one form with one recordset (a query of whichever fields, from whichever
tables, you need). In, for example, the header of this form you would
add some *unbound* combo boxes (however many you need) and a
command button that the users would click when they are done selecting
criteria. In the click event of the command button you use code that builds
a string based on what was selected in the combo boxes (the ones
without selections are ignored), then you apply this string as the filter for
your form's recordset (query). There is an excellent example of this at;

http://www.allenbrowne.com/ser-62.html

One thing you need to be aware of is that if you are using a multi-table
query as the recordset for the form, it may not be updateable depending
on how many tables are involved. If you need users to be able to update
data on this form, then test the query for this before you create the form.

--
_________

Sean Bailey

where do I do this at, in the properties click link it only allows 5.
Do you know what I mean before? Your code queries the information but
it doesn't filter on the subform (table).

You should be able to, but 5 is getting up there. Post back if you don't get
it to work.

When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?

On Sep 30, 11:18 am, Golfinray <[email protected]>
wrote:
Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.

:
I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.

Company
Plant
item #
item desc
vend #
vend name
buyer ID

In most of the cboxs I have a selection to choose from either through
value or table/query.

Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.

company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO

Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.

The subform is linked to the main form- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

Awesome, thanks for the insight. You are correct, its one table that I
data dumped information into, then I created a query off of it, I wish
these forums would allow for pictures then I could show what I mean.
Ultimately it's just one table that I would like to have a person with
combo boxes filter the selection to what is in the cbox's. I imagine
this is really easy, but I do not know Access very well, I'm teaching
myself as I go. Thanks for the response.

I would suggest you take a step back here. There are some inherent
problems in the way you are approaching this. You may also have some
table design problems, but that's hard to say without some clarification.

For example, you said you have a form based on a query that has the
following fields;

Company
Plant
item #
item desc
vend #
vend name
buyer ID

Do these fields all come from the same table? Or is this a multi-table query?

If it is the latter, then it may be appropriate. If it is the former, then you
have a table design problem which should be corrected before you spend
a lot of time and effort creating forms. The multiple entities of data that
are described by those field names should not all be in the same table.

Which brings us to the design of your form, which is certainly wrong (at least
if I am reading your posts correctly). According to what you've said so far,
your main form's recordset (table/query) has the above mentioned fields.
Within that main form you have a subform which has the exact same fields
in it's recordset.

If you are trying to set up a form where a user can select as few, or as
many, criteria as they wish to search by, then you are going about it the
wrong way. What you would do (at least one viable approach) is create
one form with one recordset (a query of whichever fields, from whichever
tables, you need). In, for example, the header of this form you would
add some *unbound* combo boxes (however many you need) and a
command button that the users would click when they are done selecting
criteria. In the click event of the command button you use code that builds
a string based on what was selected in the combo boxes (the ones
without selections are ignored), then you apply this string as the filterfor
your form's recordset (query). There is an excellent example of this at;

http://www.allenbrowne.com/ser-62.html

One thing you need to be aware of is that if you are using a multi-table
query as the recordset for the form, it may not be updateable depending
on how many tables are involved. If you need users to be able to update
data on this form, then test the query for this before you create the form.

--
_________

Sean Bailey

where do I do this at, in the properties click link it only allows 5.
Do you know what I mean before? Your code queries the information but
it doesn't filter on the subform (table).

You should be able to, but 5 is getting up there. Post back if you don't get
it to work.
:
When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?
On Sep 30, 11:18 am, Golfinray <[email protected]>
wrote:
Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have onetable?)
Then put a search function on the form. Do this by adding a combobox to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate.. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.
:
I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.
Company
Plant
item #
item desc
vend #
vend name
buyer ID
In most of the cboxs I have a selection to choose from either through
value or table/query.
Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.
i.e
company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO
Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.
The subform is linked to the main form- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

I used Allen Browns example and fixed the code up with my information
and it works like a charm. Thanks. I have another question though. I
have 5 comboboxes and when I select criteria and run filter it works
perfectly. I'd like to take this one step farther, in one of the
comboboxes I have retail store #'s and another I have supplier #'s, is
there away that when I select a retail store only the supplier's that
apply to that store show up in the supplier drop down? Currently, I
have the a master list of all suppliers in the supplier drop down, but
if I were to select a retail store # it would be nice in the supplier
cbox to have only the suppliers related to that retail store # cbox.
Make sense? Would this be row source filter of some kind?

I would suggest you take a step back here. There are some inherent
problems in the way you are approaching this. You may also have some
table design problems, but that's hard to say without some clarification.

For example, you said you have a form based on a query that has the
following fields;

Company
Plant
item #
item desc
vend #
vend name
buyer ID

Do these fields all come from the same table? Or is this a multi-table query?

If it is the latter, then it may be appropriate. If it is the former, then you
have a table design problem which should be corrected before you spend
a lot of time and effort creating forms. The multiple entities of data that
are described by those field names should not all be in the same table.

Which brings us to the design of your form, which is certainly wrong (at least
if I am reading your posts correctly). According to what you've said so far,
your main form's recordset (table/query) has the above mentioned fields.
Within that main form you have a subform which has the exact same fields
in it's recordset.

If you are trying to set up a form where a user can select as few, or as
many, criteria as they wish to search by, then you are going about it the
wrong way. What you would do (at least one viable approach) is create
one form with one recordset (a query of whichever fields, from whichever
tables, you need). In, for example, the header of this form you would
add some *unbound* combo boxes (however many you need) and a
command button that the users would click when they are done selecting
criteria. In the click event of the command button you use code that builds
a string based on what was selected in the combo boxes (the ones
without selections are ignored), then you apply this string as the filterfor
your form's recordset (query). There is an excellent example of this at;

http://www.allenbrowne.com/ser-62.html

One thing you need to be aware of is that if you are using a multi-table
query as the recordset for the form, it may not be updateable depending
on how many tables are involved. If you need users to be able to update
data on this form, then test the query for this before you create the form.

--
_________

Sean Bailey

where do I do this at, in the properties click link it only allows 5.
Do you know what I mean before? Your code queries the information but
it doesn't filter on the subform (table).

You should be able to, but 5 is getting up there. Post back if you don't get
it to work.
:
When I do master/child links, I link 3 of the subform to the main form
together and this works, but I have 5 cboxes and I'd like to link up
together, can this be done, more than 3?
On Sep 30, 11:18 am, Golfinray <[email protected]>
wrote:
Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have onetable?)
Then put a search function on the form. Do this by adding a combobox to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate.. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.
:
I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.
Company
Plant
item #
item desc
vend #
vend name
buyer ID
In most of the cboxs I have a selection to choose from either through
value or table/query.
Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.
i.e
company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO
Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanks a
million.
The subform is linked to the main form- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[ryan.fitzpatrick3]

Never mind I figured it out.

I used Allen Browns example and fixed the code up with my information
and it works like a charm. Thanks. I have another question though. I
have 5 comboboxes and when I select criteria and run filter it works
perfectly. I'd like to take this one step farther, in one of the
comboboxes I have retail store #'s and another I have supplier #'s, is
there away that when I select a retail store only the supplier's that
apply to that store show up in the supplier drop down? Currently, I
have the a master list of all suppliers in the supplier drop down, but
if I were to select a retail store # it would be nice in the supplier
cbox to have only the suppliers related to that retail store # cbox.
Make sense? Would this be row source filter of some kind?

I would suggest you take a step back here. There are some inherent
problems in the way you are approaching this. You may also have some
table design problems, but that's hard to say without some clarification.

For example, you said you have a form based on a query that has the
following fields;

Company
Plant
item #
item desc
vend #
vend name
buyer ID

Do these fields all come from the same table? Or is this a multi-table query?

If it is the latter, then it may be appropriate. If it is the former, then you
have a table design problem which should be corrected before you spend
a lot of time and effort creating forms. The multiple entities of data that
are described by those field names should not all be in the same table.

Which brings us to the design of your form, which is certainly wrong (at least
if I am reading your posts correctly). According to what you've said sofar,
your main form's recordset (table/query) has the above mentioned fields..
Within that main form you have a subform which has the exact same fields
in it's recordset.

If you are trying to set up a form where a user can select as few, or as
many, criteria as they wish to search by, then you are going about it the
wrong way. What you would do (at least one viable approach) is create
one form with one recordset (a query of whichever fields, from whichever
tables, you need). In, for example, the header of this form you would
add some *unbound* combo boxes (however many you need) and a
command button that the users would click when they are done selecting
criteria. In the click event of the command button you use code that builds
a string based on what was selected in the combo boxes (the ones
without selections are ignored), then you apply this string as the filter for
your form's recordset (query). There is an excellent example of this at;

One thing you need to be aware of is that if you are using a multi-table
query as the recordset for the form, it may not be updateable depending
on how many tables are involved. If you need users to be able to update
data on this form, then test the query for this before you create the form.
Sean Bailey

where do I do this at, in the properties click link it only allows 5.
Do you know what I mean before? Your code queries the information but
it doesn't filter on the subform (table).
On Sep 30, 1:27 pm, Golfinray <[email protected]>
wrote:
You should be able to, but 5 is getting up there. Post back if you don't get
it to work.
:
When I do master/child links, I link 3 of the subform to the mainform
together and this works, but I have 5 cboxes and I'd like to linkup
together, can this be done, more than 3?
On Sep 30, 11:18 am, Golfinray <[email protected]>
wrote:
Ryan, I would not do it that way. Build a form to pull all information into a
mainform from the one table. (i think you are saying you have one table?)
Then put a search function on the form. Do this by adding a combo box to the
form. Use the combo box wizard to do this. After you install the combo, right
click on it and get properties. Find events and go to afterupdate. Click the
little button out to the right and start the code builder. Type
Me.filter = "[yourfieldyouwantotsearchon] = """ & Me.comb# & """"
Me.filteron = true
The combo # will be listed, like combo34 or combo12.
:
I have a form that is linked to a query which runs a table. There are
7 comboboxes that are are linked up to the query, each cbox is a field
below that is in the query.
Company
Plant
item #
item desc
vend #
vend name
buyer ID
In most of the cboxs I have a selection to choose from eitherthrough
value or table/query.
Below these is a subform which is the table the query pulls. When I
enter what I want in the cboxes above the subform ,how do I get
correct data to show on the subtable below. Ideally whatever is
selected up top if one cbox or all cboxes are filled out, it should
bring related information in the subform.
i.e
company = US
plant = 8103
item # = blank
item desc = blank
vend # = blank
vend name = blank
buyer ID = TO
Now I have only entered in company, plant, and buyer ID, I'd like
everything that matches this criteria to get brought up in the subform
table below, but it doesn't and I don't know why. When I go into the
actual query and enter the same information, the data shows up when I
run the query. What should I do? Does this make sense? Thanksa
million.
The subform is linked to the main form- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -