I need help in the following situation.
I have retrieved some records from my Access table by giving a simple select statement and have just simply displayed these records on the page horizontally.
Also i have added a anchor tabl to each record so that when they get displayed i click on them and they take me to the other page.
There is a field called order id which i need to store somewhere and basically use this order id in the next page.
The reason for doin so is i want to use this order id for performing an update on the order i have clicked so that it gets updated.
Something like this:
Update tblorder Set AgentName(whatever user selects in the dropdown) where orderno="Value from the previous page"
I can either do an update or insert..which i am confused..so need help in this too.
But main thing is how should i call the order no and use it in my query on the next page/form/screen?