Continouus Form, with updates via Combobox (1 Viewer)

molrunner

New member
Local time
Today, 15:05
Joined
Jan 3, 2017
Messages
7
I have a request to generate a form, where the user can select different adddress based on a dropdown combobox on the same form.

So I created a Continuous Form, but the Taxcode is updating all the addresses and not treating them as a "new" page. Am i taking a wrong route with a Continuous Form? If not, what should i be looking at?

In a normal use, there will be at least 3 different addresses, and they are required to be on 1 form. I have attached a screenshot below of what is the basic setup.

Ideas?
 

Attachments

  • COMSelection.PNG
    COMSelection.PNG
    10.5 KB · Views: 72

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:05
Joined
Aug 30, 2003
Messages
36,118
It sounds like the combo doesn't have a control source. It needs to be bound to a field in the table to have a value unique to each record.
 

molrunner

New member
Local time
Today, 15:05
Joined
Jan 3, 2017
Messages
7
Thanks Pbaldy, I did not have a Control Source. I have added it now, but that made the Recordset Not Updateable.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:05
Joined
Aug 30, 2003
Messages
36,118
I would expect the field to be in the same table as the other field; is it not?
 

molrunner

New member
Local time
Today, 15:05
Joined
Jan 3, 2017
Messages
7
It is not. I created a query to pull the addresses from another table, based on state selected. I can create a temp table that Makes a table then deletes the table afterwards, but i was hoping there was a easier method.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:05
Joined
Aug 30, 2003
Messages
36,118
What is your table structure?
 

Users who are viewing this thread

Top Bottom