Database Question

[Guest]

I am working on an employees database and I am trying to track union points
for each employee. I have set up a form with the employees last name, first
name, date, points and reason but I can't figure out how to get it to update
the table. I also have designed a query that is telling the form what reason
code to lookup and it pulls the points over. I think I might have to do a
subform to update the table but I am not sure.

 

[Powderfinger]

Your form's "Record Source" should be set to the table name. And the "Allow
Edits" property should be set to Yes.

 

[Keith Wilby]

I am working on an employees database and I am trying to track union points
for each employee. I have set up a form with the employees last name,
first
name, date, points and reason but I can't figure out how to get it to
update
the table. I also have designed a query that is telling the form what
reason
code to lookup and it pulls the points over. I think I might have to do a
subform to update the table but I am not sure.

Hi Julie, you seem a little confuzzled as to what does what. Your form
should be bound to your table or query in order to be able to update the
recordset. Open the form in design view, open the "properties" box and look
at the "data" tab - the name of your table or query should be selected for
"Record Source".

HTH - Keith.
www.keithwilby.com