Access 2007 - Combo Box Question.

[Guest]

Basically, this is what I'm looking at doing.

I'm creating a database, using a lot of drop down items in the form of combo
boxes for quick selection of items to put into a main database.

The user of the database wants to be able to edit/add/delete items from
these multiple tables in a singular form, with drop down combo boxes to
select the item he wants to delete and push a button to delete it.

I don't know how possible it is to have multiple combo boxes (and in turn,
the use of multiple non-connected tables) in the same form or not? And if
so, how would I go about doing that?

 

[Guest]

You can create a three forms, one for each table.
Then create another form and add to it three sub forms, one for each form
you created, when there is no link between this sub forms.

To make it look nicer, and not one long main form, create a TAB in the main
form, and in each TAB create another sub form, that way the user will be able
to ADD/UPDATE/EDIT each table from the same form.

But you should inform the user, that by doing that the form will load
slower, because it has to retrieve data from three tables.
I prefer to open a table only when you need to, and not open 3 tables when
you need to update only one of them.

 

[Guest]

Thank you for the input.

In fact, I am going through a different route, which you did mention.
Instead of having everything on one form, I'm going to create a multitude a
forms, having them all connected (like the switchboard manager thing) with
one "main" form, then selected what data they want to update from the one
form, taking them to the appropriate "sub-form" to change data, and bringing
the user back to the main directory with another button. Meh, it's simple
and it does what I need it to do.

Thanks again!