sub forms and list/combo boxes

magdalene

New Member
Joined
Sep 13, 2006
Messages
5
i have set up all tables that i will require. i want to creat a sub form with the certain tables where i will be able to enter information and also have list boxed. i have tried this before and it worked except whenever i use the list box and click on the selected item it fills in all the other records with the same data
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
I'm not sure I follow what you're trying to do. Normally... and especially at a beginner level, a listbox does one of two things. First, it simply displays a list of options that the user can select from. Once they make a selection, it is entered into the field the list box is associated with. This is the most common use of a list box and is used to force consistency... Example: Your list box might contain John, Mary and Joe. The user selects John which is entered into the record, preventing the user from entering Jon or johnnie.
The second and what I feel is a more powerful use of a list box is that the user can make a selection from the list box ... usually some unique field in your table(s), which will display the record associated with that selection.

And yes, there are other ways to use a list box, but that takes more indepth knowledge of Access and VBA.

So, after that long winded explanation, I'm thinking that you need to go back to the creation of your form.. or what you call your sub form. At this time, with what little information you've provided, I'm at a loss as to how ALL records are being updated via your list box.... I know it can happen, I just think you need to provide more detail. Example - a sub form is usually associated with a parent form. Is your list box on your parent form or actually in your sub form? If you have both, what are you trying to do with the list box? Make a selection or display a record?
 

Forum statistics

Threads
1,137,339
Messages
5,680,910
Members
419,940
Latest member
WilliamPorter

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top