Addind Data To A Query From A PAGE?? 1

[Dashsa]

Hello,
I am VERY Fustrated!!!
I have a Query that Displays data, I also have a Data Access Page that Gets info from the Query and has other fields that users must fill in But when i try to fil in a field i get an ERROR saying that it can not add the data ?

To Explain a bit better:

Images Table:
Has ID, ImgSrc ,Status,PO number

The Query looks at this table and only displays records that have a Status of "UNread"

The Data Access Page Displays 4 input boxes which it fills in the details from the Query and i need the users to fill in One other box and change the value of the box filled in by the query
So they change the STATUS field t "READ"
so that the Query will not display it again.

So Why wont it let me add data to the Query from the Data Access Page??? PLEASE HELP!!!

Thank You
David

 

[fneily]

You must supply the Primary key on the DAP. So make sure that the primary key is in your query, that the query is editable, then create the DAP. You say it has "other fields" - are they from the same table? Then you should have no problem fixing your query. If they're from another table, again connect the tables in a query making sure the query is editable (include primary keys) then create your DAP.
Do you have experience in VBScript?

 

[Dashsa]

Yes thats it i stumbled on the answer as i got your reply...
Thank you very much