New Records

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

Guest

I have created a form in design view. I have AllowAdditions in the form
properties selected as yes but still am unable to add or create new records.
What can I do to fix this? Thanks!
 
awach said:
I have created a form in design view. I have AllowAdditions in the form
properties selected as yes but still am unable to add or create new records.
What can I do to fix this? Thanks!
Click to expand...

More than likely you have the form bound to a non-editable data source. Many
queries for example do not allow edits.
 
I don't think that my form is bound to any queries. I made a combo box with
values that I entered (the advice you gave from the last post). I have the
corresponding text boxes (reference number and description) and one other
text box for the client name. All of these fields are unbound. Is there
something else I should try?
 
Also, the records aren't being saved either.

awach said:
I don't think that my form is bound to any queries. I made a combo box with
values that I entered (the advice you gave from the last post). I have the
corresponding text boxes (reference number and description) and one other
text box for the client name. All of these fields are unbound. Is there
something else I should try?
Click to expand...
 
awach said:
I don't think that my form is bound to any queries. I made a combo box with
values that I entered (the advice you gave from the last post). I have the
corresponding text boxes (reference number and description) and one other
text box for the client name. All of these fields are unbound. Is there
something else I should try?
Click to expand...

Well, if your controls are unbound then they don't save data (that is what
unbound means).

Does your form have a RecordSource at all? If not then it is not bound either.
For the data on a form to be saved the form must be bound to a table or editable
query and your controls must be bound to the fields in that Table or query.
 
Back
Top