Selecting a record based on a list box

[Goldar]

I have a list box which is based on a table with the following fields:
Account #, sequence #, description, subAccount descriptiion (null form
primary account, not null for subAccount). The table is indexed on the first
two fields.
My list box has specifies 4 fields, with the first field as the bound field.
The field widths are specified as: 0.6";0.2";1";1". When I run the form, the
list box display is correct. Whenever I select a primary account (null in
SubAccount) field everything works fine. When I select a subAccount , the
list box highlights BOTH the subAccount entry as well as the Primary account
entry. The only data that is displayed in bound fields is that of the Primary
account. No matter which Sub Account is selected, only the Primary Account
data is displayed. How do I get the Sub Account data to be displayed?

Thanks...

 

[Jeanette Cunningham]

Hi Goldar,
build a second listbox to display the subaccounts for the main account
selected in the first listbox.
You will probably need a subform to display the info for the sub account.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia