Creating a new record on a form where its' record source is a Quer

[Guest]

Is it possible to do this? I have a form "frmPipeline" with its' data source
being "qryUpdatePipeline".

The qryUpdatePipeline has its' record source being "tblPipeline".

I want users to be able to add records using the form I created however when
I try to do this the arrow with the asktricks (used to creat a new record) on
the bottom of the form is blocked out.

Any suggestions??

Thanks.

 

[fredg]

Is it possible to do this? I have a form "frmPipeline" with its' data source
being "qryUpdatePipeline".

The qryUpdatePipeline has its' record source being "tblPipeline".

I want users to be able to add records using the form I created however when
I try to do this the arrow with the asktricks (used to creat a new record) on
the bottom of the form is blocked out.

Any suggestions??

Thanks.

Not all queries are updateable.
Open the query itself.
You'll most likely find that the New Record button is also grayed out.

See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated