Form not working.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have access 2003 and I have made a switchboard to open two other forms.
Once the switchboard is opened and the form to add a new record is selected,
the form is opened but will not save the record. I have used the button
wizards to help with the VB codes but I'm lost as to why the form will not
save a record. Thanks in advance for any help
 
is the form bound to a table, or updateable query or recordset? is the
form's AllowAdditions property set to Yes? when you open the form by itself
(not through the switchboard), can you enter and save a new record?
 
Tina,
The form is not bound to a table or query. I can not find the
allowadditions property. I have found a way to do it in VB Script but I
would like to do it without VB Script. Thanks again for any help.
 
well, if you enter data into form controls, you can only save the data to a
table if
1) the form is bound to a table, or
2) the form is bound to an updatable query, or
3) the form is bound to an updatable recordset, or
4) you write code to programmatically write the data to a table, using a
recordset or an update query.

there may be other ways that i'm not familiar with, but that list covers the
common choices. since you say your form is unbound, is there a business or
technical reason why you don't just bind the form to your data table?

btw, if you open the form in design view, click View | Properties from the
menu bar to open the Properties box (if it's not already open), and click
the Data tab, you'll see the AllowAdditions property about halfway down the
list. if you click once on the AllowAdditions line (to place your I-beam on
that line) and press F1, you'll go straight to the appropriate topic in
Access Help.

hth
 
Back
Top