Diffculty with Form

[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

 

[Jeff Boyce]

Dave

Are you using the AfterUpdate event to requery the listbox? Does the
listbox's 'source' include a criterion that looks to the combo box for
input?