How do I ..?

  • Thread starter Thread starter Milli
  • Start date Start date
M

Milli

Hi
I have a few combo boxes on a form that are linked to a
table.
Questions.
1.Is the table updated the same time the info is filled
in the combo box?
2.How can I ensure that incomplete/incorrect info does
not enter the table i.e If I move off focus from a combo
box with incorrect info and if the combo box is locked,
this info is stored. I then have to use an
edit "method"to correct this.
3.How can I have all the info filled in , ensure that the
info filled in is correct before accepting this into the
table?
Thanks
Milli
 
1. Selecting something in a combo box doesn't save any
data. The record is saved in it's entirety when you
navigate to a different record or "save" the record using
several options within Access.

2. Table design is the key to saving the data in the
manner that you want. Use the validation rules and data
save requirements (Required - Yes/No) to configure your
plan. If you have code in an event on the combo box that
locks it, then you'll need some amount of code to make the
record editable again but I'm not sure of your reason for
locking the combo box.

3. Access uses the safeguards that I mentioned in my
response to question # 2 above before it saves a record.
If you have these setup properly your data integrity
should be good. You may need some advanced macro building
or coding if you want to validate by comparing data from
multiple fields at one time.
 
Thanks. Your time invested in my questions is very much
appreciated.
I am still finding the balance between VB coding and
using the built in features of access.
Once my form is filled in how do I write this info to the
table. I am aware that access can do this for you, how
would I achieve this using VB code.

Thanks again
Milli
 
Back
Top