Brain cramp, cannot add new record to form

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

I've got what is supposed to be a data entry form which is not working
properly. I call this form from several different forms, so I've set its
RecordSource to filter based on a function.

My intent was to disable "Allow Additions" when called from some forms, and
not others, but I cannot get it to display a New Record no matter what I do,
and the Add Record button is disabled in the navigation buttons. This is
driving me crazy. I'm sure there is something simple I'm missing, but cannot
for the life of me figure out what it is.

Setup looks like:
Continuous form
Allow additions = Yes
Data Entry = No
RecordSource: SELECT * from tbl_X WHERE [LD_ID] = fnLDID()
RecordSetType:DynaSet
Navigation Buttons: Yes
 
The SQL in the record source says that it has to be equal to something. If
you are creating a new record, there's nothing to equal.
 
Dale Fye said:
I've got what is supposed to be a data entry form which is not working
properly. I call this form from several different forms, so I've set its
RecordSource to filter based on a function.

My intent was to disable "Allow Additions" when called from some forms,
and
not others, but I cannot get it to display a New Record no matter what I
do,
and the Add Record button is disabled in the navigation buttons. This is
driving me crazy. I'm sure there is something simple I'm missing, but
cannot
for the life of me figure out what it is.

Setup looks like:
Continuous form
Allow additions = Yes
Data Entry = No
RecordSource: SELECT * from tbl_X WHERE [LD_ID] = fnLDID()
RecordSetType:DynaSet
Navigation Buttons: Yes
Click to expand...


Is the database file itself read-only? If this database is secured with
user-level security, does the current user have update permissions on the
table and the form?
 
No, that's not it.

I just realized that it is not based on a table, it is based on a query,
that isn't updateable.

I knew it had to be something simple.

Thanks anyway. Sometimes I just need someone jog me out of my stupor!

----
Dale



Jerry Whittle said:
The SQL in the record source says that it has to be equal to something. If
you are creating a new record, there's nothing to equal.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Dale Fye said:
I've got what is supposed to be a data entry form which is not working
properly. I call this form from several different forms, so I've set its
RecordSource to filter based on a function.

My intent was to disable "Allow Additions" when called from some forms, and
not others, but I cannot get it to display a New Record no matter what I do,
and the Add Record button is disabled in the navigation buttons. This is
driving me crazy. I'm sure there is something simple I'm missing, but cannot
for the life of me figure out what it is.

Setup looks like:
Continuous form
Allow additions = Yes
Data Entry = No
RecordSource: SELECT * from tbl_X WHERE [LD_ID] = fnLDID()
RecordSetType:DynaSet
Navigation Buttons: Yes
Click to expand...
Click to expand...
 
Back
Top