Plz Help...

[Guest]

The database I am trying to make is to determine the amount of items in a certain roo

I have three tables. Fixtures, Furniture and Rooms

What I am trying to achieve is to have a Form with a combo box where I can look up the room

Once I have selected the room and list box will populated with the items in this room

After that I want a textbox to be populated with the quantity of the item selected

I am getting a different result.
My combo box is populated with the right information. (RoomID
However, the list box is already populated will ALL the items from the Fixtures or Furniture table and not the specific items from that room. The quantity doesn't work at all

Any help with this frustrating problem will be rewarded with FREE apple pie. :-

Thank you

Dave

 

[JulieD]

Hi Dave

the list box needs to include a reference to the combo box with the room
info on the form in its row source ... if you go into the properties of the
list box, choose ALL and click on Row Source then click on the ... now you
will probably have to add the room ID field to the query grid, then
underneath that field click in the criteria line and use the expression
builder to reference the room combo box on the form.

exit out of the query grid saying Yes when it asks you to update the SQL
statement, save & test the form ... then on the OnChange event of the combo
box, you need to put a command that requeries the list box

me![listbox name].requery
should do it for you.

Hope this helps
JulieD

The database I am trying to make is to determine the amount of items in a certain room

I have three tables. Fixtures, Furniture and Rooms.

What I am trying to achieve is to have a Form with a combo box where I can look up the room.

Once I have selected the room and list box will populated with the items in this room.

After that I want a textbox to be populated with the quantity of the item selected.

I am getting a different result.
My combo box is populated with the right information. (RoomID)
However, the list box is already populated will ALL the items from the

Fixtures or Furniture table and not the specific items from that room. The
quantity doesn't work at all.