update table from form

[ugo_lavoie]

HEy,

this is normally pretty basic stuff but i dont know if i'm tired or
what but right now i just can get it.

Heres the problem...

I have a form base on a table. 4 field : ID_Seller, Name_Saleman, Area,
ID_equipment.
I already have the ID and name entered in it. Now i want to be able to
add/change info in it, so normally i open the form and (i have a drop
down list to select the ID) select the ID. Everything is hook together
with Dlookup (from the ID_Seller).So as i select the ID, the name and
the rest of information comes with it. (but the record selector stays
at 1 - probably my problem). Now that I've selected the right ID, i
enter the area and ID equipment and when i try to save it, it says that
i cannot double the data in the field etc

All i want to do is be able to enter my missing data from the form..
thx

[ugo_lavoie]

i will ad some info...

i dont want to move with the record selector cuz it will take too long
to move from 1 to another record.
And my ID-Seller doesnt match my record like....ID 999 is the record 249

[Jamey]

sounds like you're using an unbound form or at least unbound controls
to display the data for the selected ID. if you are using an unbound
control to display the data, or a calculated control, for that matter,
you can't save the data to the table, because the form doesn't know
what to do with it. to fix it:

first, you have to bind the form to the underlying table, and it sounds
like you'd best accomplish that for your purposes by using a query or
SQL statement for your Record Source for the form itself.

the form probably needs something like this for the Record Source:

SELECT SalesTable.Area, SalesTable.ID_equipment FROM SalesTable ORDER
BY SalesTable.Area;

then you'll have to build put a combination box (i think you said you
already have one to select the correct ID_Seller). that should be
unbound and in the header. It should have no Control Source (unbound)
and the Row Source should be set to an independent SQL statement to
give you all the seller IDs. This works best if those are maintained in
a seperate table as primary key values. that Control Source will look
like this:

SELECT SellerTable.ID_Seller FROM Seller.Table ORDER BY
SellerTable.ID_Seller;

the last thing you have to do is requery your selected data for your
Area and ID_equipment controls with the After Update event of the
ID_Seller combination box:

Sub cboIDSeller_AfterUpdate ()

Dim strIDSeller as String

strIDSeller = Me.cboIDSeller.Value
Me.RecordSource = "SELECT SalesTable.Area, SalesTable.ID_equipment " &
_
"FROM SalesTable " & _
"WHERE SalesTable.ID_Seller = """ & strIDSeller & """ " & _
"ORDER BY SalesTable.Area;"
Me.Requery

End Sub

that oughtta do it, unless there's something else about your question
that I don't understand.

[ugo_lavoie]

thx i'll give it a shot