Update Table/Data Entry Form

[dtoney]

I have a table I need to update from a form. Would it be poor design to
allow the source be the table? Or should the form's source be a query? I
have it set up for the source as the table, but the choices from the list
box, dates, etc are not updating on the table. The new name, address, etc
are updating, but the options are not.

 

[jahoobob via AccessMonster.com]

Answer #1: No, it is not necessarily poor design to have a table as the
source of a form. Tables and Queries are both sources of forms dependeing on
the situation.
Answer #2: First thing to do is see if the Control source of the fields in
your form have a table field in them. In list and combo boxes, make sure of
the control source and the bound column.
If this doens't lead you in the right direction, you need to provide a little
more information such as what fields are in the table and what do you mean by
the options are not updating.

 

[dtoney]

What I have is a payment schedule for Cobra insurance that I need to keep
track of the former employees' Cobra payments. The list box shows whether he
wants EE (employee only) EE/SP (Emp & spouse) FAM(family coverage), etc. The
employee type is was he an employee, agent, or other employee type. There are
also various dates. I have a subform for the payments (linked by SS#). I
have JUST inserted an event procedure like this:
If Me.Dirty Then
Me.Dirty = False
End If
which seems to be working. I was just wondering if this was a "BEST
PRACTICE" or if there was some other means of getting the data to the table.