Selection table update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay LaViolette - 09 Feb 2006 20:01 GMT

I am using a selection table made up of data from a number of tables to
populate cascading combo boxes. When I add new data to the tables I
want the selection table to update. I am having trouble because the
table is locked by the form with the cascading combo boxes.

This is in a multi-user setting with a split front end and back end.

What is the best method for doing this.

Please advise.

Thanks.

Reply to this Message

Rick B - 10 Feb 2006 15:18 GMT

What is a "selection table"?

Signature

Rick B

>I am using a selection table made up of data from a number of tables to
> populate cascading combo boxes. When I add new data to the tables I
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Jay LaViolette - 13 Feb 2006 00:44 GMT

Sorry, by selection table, I mean a table that populates the cascading
combo boxes.

e.g.

Col A, Col B from Table A Col A, Col B from table b

Rum 1 Pina Colada 1
Rum 1 Punch 1

Vodka 2 Collins 2
Vodka 2 Tonic 2

My problem is I am using a maketable query to combine tables like in A
and B. When a new value is added the maketable query is run. I can't
run the maketable query when the form is open as it locks the
"selection table'. Not a problem with one user, I close the form, but
when more than one user has the table open...

any suggestions?? Thanks for your time.

Reply to this Message

Larry Linson - 11 Feb 2006 02:45 GMT

>I am using a selection table made up of data from a number of tables to
> populate cascading combo boxes. When I add new data to the tables I
[quoted text clipped - 4 lines]
>
> What is the best method for doing this.

If I want the user to be able to select a particular record, I create a
Query to use as Row Source for the Combo that shows each distinct
identifying item of information.

Larry Linson
Microsoft Access MVP

Reply to this Message