Recent content by chemram

How can I get controls on a form to become active or inactive depending on the value of another form field? eg. if a field called "exit date" is null it will make the control "exit reason" inactive until a date is put in..??

Thanks DH, but i'd already got that far.....no worries though, solved the problem by usin a subform.... Thanks Anyway.. Chemram

I need my one of my db's forms to have data from 2 different tables on the one form... eg. The form's record source is TblClients, and it has a button to open another form using the same "ClientID" field as a reference, so if client 12 was on the first form, the new form would open with client...

Thanks Skip, But I was looking for a way just to isolate this function from within Access, so normal mouse functions still exist...

How can I stop my DB scrolling through records when the wheel on a scroll mouse is used?

I am writing a database for a local government authority that refers to clients with a unique ID number, made up of the first 3 letters if the surname, then the first 3 letters of the Given name , then th Date of birth.... eg: John Smith, born 12/3/1965 would become "smijoh1231965". How would i...