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

T

tt_Gyrl

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.
 
F

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.
Click to expand...

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
 
Top