Brain cramp, cannot add new record to form

[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()
RecordSetTypeynaSet
Navigation Buttons: Yes

 

[Jerry Whittle]

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.

 

[Dirk Goldgar]

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()
RecordSetTypeynaSet
Navigation Buttons: Yes

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?

 

[Dale Fye]

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

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.

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()
RecordSetTypeynaSet
Navigation Buttons: Yes