ComboBox Parameter not working

  • Thread starter Thread starter G.
  • Start date Start date
G

G.

I have a query based on 8 tables. It has 135k rows. I created a form with a
combo box and a command button so that users can filter through the query. I
have done this on previous DB's and am not sure what I am doing wrong. The
problem however seems to be with the Criteria statement I enter into the
query.

To make it simple I created a separate query with 1 field and 5 rows. The
combo box is based on the 5 rows so it has 5 selections. I then created the
command button and then entered [Forms]![FrmPar]![Pt Type] into the Criteria
area of the Pt Type field of my query.

It runs ok at first. However, if I exit the db and open it again first I get
the error Your MS Access DB contains missing or broken reference to the file
GWAB1.OCX version 1.0. Also, the items in the combo change or dissapear. I
investigate by looking at the query that the combobox is based on and to my
surprise, I may have only 1 of the items I entered, or I may still have 5 but
one of them is repeated twice and another is not there. If I remove the
Criteria expression [Forms]![FrmPar]![Pt Type] from the query, all the
trouble goes away but I then cannot filter. I have been working to resolve
this for many hours taking many different approaches but nothing has worked.

If anyone has insight please please help. My head and eyes hurt.

Thank you.
 
Hi,

it sounds almost as you have a broken reference in your database. GWAB1.ocx
points to a groupwise Activex object. You could check your references by
opening a VBA module, and look at Tools -> references for any broken
references.
 
Thank you. I think this is the right track.

Should I open the specific module for the Command Key? Or a New Blank
Module? I am not sure how I would tell if a reference were broken and if one
is broken, how to fix it? These questions may be too broad so fogive me if
they are. Any guidance is appreciated.

Thank you,
Gennady

Noëlla Gabriël said:
Hi,

it sounds almost as you have a broken reference in your database. GWAB1.ocx
points to a groupwise Activex object. You could check your references by
opening a VBA module, and look at Tools -> references for any broken
references.
--
Kind regards
Noëlla


G. said:
I have a query based on 8 tables. It has 135k rows. I created a form with a
combo box and a command button so that users can filter through the query. I
have done this on previous DB's and am not sure what I am doing wrong. The
problem however seems to be with the Criteria statement I enter into the
query.

To make it simple I created a separate query with 1 field and 5 rows. The
combo box is based on the 5 rows so it has 5 selections. I then created the
command button and then entered [Forms]![FrmPar]![Pt Type] into the Criteria
area of the Pt Type field of my query.

It runs ok at first. However, if I exit the db and open it again first I get
the error Your MS Access DB contains missing or broken reference to the file
GWAB1.OCX version 1.0. Also, the items in the combo change or dissapear. I
investigate by looking at the query that the combobox is based on and to my
surprise, I may have only 1 of the items I entered, or I may still have 5 but
one of them is repeated twice and another is not there. If I remove the
Criteria expression [Forms]![FrmPar]![Pt Type] from the query, all the
trouble goes away but I then cannot filter. I have been working to resolve
this for many hours taking many different approaches but nothing has worked.

If anyone has insight please please help. My head and eyes hurt.

Thank you.
Click to expand...
Click to expand...
 
Hi,

it doesn't matter which module you open, you can create a new one if you
want. The important fact is that you enter the VBA window and can see the
toolbar, click the toolbar option Tools -> menu option References. The
references window will open. In this window you can see all used references
to add-ons and dll's. If one is missing it will state so. Uncheck the
missing reference. Close the window and try to restart.
beware that, if certain features of the app use this add-on, they will no
longer work, so it's a good idea to make a back-up first.
--
Kind regards
Noëlla


G. said:
Thank you. I think this is the right track.

Should I open the specific module for the Command Key? Or a New Blank
Module? I am not sure how I would tell if a reference were broken and if one
is broken, how to fix it? These questions may be too broad so fogive me if
they are. Any guidance is appreciated.

Thank you,
Gennady

Noëlla Gabriël said:
Hi,

it sounds almost as you have a broken reference in your database. GWAB1.ocx
points to a groupwise Activex object. You could check your references by
opening a VBA module, and look at Tools -> references for any broken
references.
--
Kind regards
Noëlla


G. said:
I have a query based on 8 tables. It has 135k rows. I created a form with a
combo box and a command button so that users can filter through the query. I
have done this on previous DB's and am not sure what I am doing wrong. The
problem however seems to be with the Criteria statement I enter into the
query.

To make it simple I created a separate query with 1 field and 5 rows. The
combo box is based on the 5 rows so it has 5 selections. I then created the
command button and then entered [Forms]![FrmPar]![Pt Type] into the Criteria
area of the Pt Type field of my query.

It runs ok at first. However, if I exit the db and open it again first I get
the error Your MS Access DB contains missing or broken reference to the file
GWAB1.OCX version 1.0. Also, the items in the combo change or dissapear. I
investigate by looking at the query that the combobox is based on and to my
surprise, I may have only 1 of the items I entered, or I may still have 5 but
one of them is repeated twice and another is not there. If I remove the
Criteria expression [Forms]![FrmPar]![Pt Type] from the query, all the
trouble goes away but I then cannot filter. I have been working to resolve
this for many hours taking many different approaches but nothing has worked.

If anyone has insight please please help. My head and eyes hurt.

Thank you.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top