Search results

using WHERE= id like my command button to open a form called "QuotationAdditionalsDetails" using the field "AdditionalsDetailsID (Primary Key) in the table "QuotationAdditionalsDetails" please assist me in this

When opening a Report i get an error that says the search key was not found, after clicking ok it opens the Report normally, but i could do without the error. how do i get rid of this problem.

but il still send u a copy of my db shortly.

John it was my filter i set it to ="FormPrimaryKey" and its sorted.

ok the form with the problem is Notification of Additionals is Access 2010 ok or do u want it in 2007

...Native Auto Number

Marvellous, thanks a great deal Reflex...!

Hi john thanks that helped partially because now it stays on the current record but, my autonumber still increases as if it is still moving on to a new record.

when i toggle through my fields using tab, once it gets to the last field it doesnt stop or begin from the top, it creates a new record, how do i restrict it to stay on the current record.

Thanks, will this only work with selecting records individually, or can i apply it with the OnDirty Function?

GoodMorning My AutoNumber Field Remains Empty is there something i Missed?

thanks guys, Quotation cannot be my main table anymore due to certain functions i need my system to perform, so i want to create a new table which will be my main table in other words "Quotation will answer to the new table" do i create this table like i would create an ordinary table or is the...

Hi Lagbolt thanks for your reply what i actually meant was a tabbed page not a tab control, ive found what im looking for, but thanks anyway.

hi all, how do i change a form into a TAB form, and make it appear in my main table as a Tab

Good Day My Main Table in my Database is "Quotation", what do i need to do in order to create a new Main Table called "Quotation Tracker" and "Quotation" would now be under "Quotation Tracker"

what would my control source be, at the moment the field displays this #NAME?

thanks, hopefully you saved me again.

my requirements is that Additional Quotes return the amount of records with the same Quotation ID number from the table Quotation

where do i apply the code?

...okay no need to reply i see blue bits need to change to my need thanks a million.