Stupid Question about Forms

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

Guest

Okay, so I built a form in design view. I am wanting to use this form to
enter data. For some reason I can't add new records. It doesn't give me the
last button that I normally use to add them. Any ideas on how I can get it
fixed?
 
Is your form based on a table or query yet? In other words, have you looked
at the form's properties and asoociated it with a Record Source?
 
Terri said:
Okay, so I built a form in design view. I am wanting to use this
form to enter data. For some reason I can't add new records. It
doesn't give me the last button that I normally use to add them. Any
ideas on how I can get it fixed?
Click to expand...

1. Make sure the form's AllowAdditions property (on the Data tab of the
form's property sheet in design view) is set to Yes.

2. Make sure the form is actually bound to the table or query you want
to add records to -- check the form's RecordSource property (also on the
Data tab of the property sheet).

3. Make sure the form's RecordSource table or query is updatable and
allows additions. Check this by opening the table or query directly in
datasheet view, and see if you can edit and add records there. If you
can't, then (a) if it's a table, check whether you have permissions to
modify data in that table; (b) if it's a query, look into the help
topics, "When can I update data from a query?" or "Troubleshoot
queries".
 
Thanks much! I got it.

DissentChick said:
Is your form based on a table or query yet? In other words, have you looked
at the form's properties and asoociated it with a Record Source?
Click to expand...
 
Okay, I got it so it says I can add another record and it tells me there are
143 records (which is correct) but they are all blank. When I go to enter a
new record, it makes all previous records the exact same as the new one. Any
suggestions to fix this problem?
 
Terri said:
Okay, I got it so it says I can add another record and it tells me
there are 143 records (which is correct) but they are all blank.
When I go to enter a new record, it makes all previous records the
exact same as the new one. Any suggestions to fix this problem?
Click to expand...

Your form was unbound before, wasn't it? Then your controls are
probably also unbound, even though you've now bound the form to a
recordsource. Open the form in design view, select each control in turn
that should show data, open its property sheet to the Data tab, and
enter or choose the approopriate field name for the Control Source
property.
 
Thank you! That worked.

Dirk Goldgar said:
Your form was unbound before, wasn't it? Then your controls are
probably also unbound, even though you've now bound the form to a
recordsource. Open the form in design view, select each control in turn
that should show data, open its property sheet to the Data tab, and
enter or choose the approopriate field name for the Control Source
property.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top