Please help me ASAP- Retriveing and Submitting data

[Melissa101]

I have a form. One of the fields is a drop down list which retreives data
from a table which is what I want it to do...but then I need the selected
data to be stored to my main database.....so I need it to retreive the list
of names to choose from but then I need the name which is selected to be
stored in the main datasource...

People are supposed to be using the form today and it's not storing that
data to the db!!!!!!!!

 

[Adam Harding]

Melissa101

Hello again, how goes?

Go into design of the form and check which field the control is bound to and
more importantly where it resides. What it sounds like is that your control
is bound to the secondary data source AS WELL AS displaying the data from the
secondary source.

The actual field should be Field1 on Main Dataconnection, and its default
values are then selected from the secondary data source.

This, almost certainly, is causing your problem.

Cheers

your ever so friendly helper Adam