Difficulty with cbx

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two access databases.
I am trying to update a form in one to mimic something a form does in the
other. It should be very simple. I have a combo box that is populated by
the "zlookup type" table. For some reason, when I select an item from the
dropdown, rather than appearing in the box, I get an audible bell. Nothing
happens. I have made many of these in the past without a problem. What
could possibly be getting in my way?

TIA
 
I have two access databases.
I am trying to update a form in one to mimic something a form does in the
other. It should be very simple. I have a combo box that is populated by
the "zlookup type" table. For some reason, when I select an item from the
dropdown, rather than appearing in the box, I get an audible bell. Nothing
happens. I have made many of these in the past without a problem. What
could possibly be getting in my way?

TIA
Click to expand...

An incorrect definition of the combo box, bad code, most anything.
It's awfully hard to diagnose at this distance though!

Please post the field definitions of your [Zlookup type] table, and
the following properties of the combo box:

Control Source
RowSource (post the SQL if it's a query)
Bound Column

and if any of the properties on the Events tab contain [Event
procedure] please post the code.

John W. Vinson[MVP]
 
John,
In my efforts to progress to what I ultimately want, I have created
TypeSubType table. This table has a primary key called "Designator" -
number. It has a field, "type" and another, "subtype". These are number
fields (previously tried them as text field with same beeping result.

My lookup table for the first combobox is called, "zlookup type". It has a
"Type" field and a "TypeID" field. The first is text the other is
autonumber. This lookup is intented for the first combobox on my form.

The form is called "Form1". The first combobox is called "typecbx". The
control source for typecbx is typesubtype.
Row Source Type: Table/Query
Row Source: SELECT [zlookup: Type].[TypeID],[zlookup: Type].[Type] FROM
[zlookup: Type]
Bound column:1
Column count:2 (0",1")

The dropdown is properly populated, but will not select. If I remove the
bound aspect, it will select. However I need the data to populate the table.
Once I get that done, then I need it to drive the population of the second
combobox "subtypecbx".

Thanks for your help.



John Vinson said:
I have two access databases.
I am trying to update a form in one to mimic something a form does in the
other. It should be very simple. I have a combo box that is populated by
the "zlookup type" table. For some reason, when I select an item from the
dropdown, rather than appearing in the box, I get an audible bell. Nothing
happens. I have made many of these in the past without a problem. What
could possibly be getting in my way?

TIA
Click to expand...

An incorrect definition of the combo box, bad code, most anything.
It's awfully hard to diagnose at this distance though!

Please post the field definitions of your [Zlookup type] table, and
the following properties of the combo box:

Control Source
RowSource (post the SQL if it's a query)
Bound Column

and if any of the properties on the Events tab contain [Event
procedure] please post the code.

John W. Vinson[MVP]
Click to expand...
 
Back
Top