Filthy_Phil
New member
- Local time
- Today, 20:23
- Joined
- Dec 19, 2007
- Messages
- 3
Hi,
I know I am new to the forum. I registered as I am using MS Access to manage my Repairs and Maintenance jobs at work and need some help.
I use 3 forms, one to record a job, one to manage a job... add comments, purchase order details, that kinda stuff, and a form to close the job.
I also use the switch board to make everything look a bit more swish. Obviously it is fairly easy for the form for adding a job, because switch board manager allows me to open a form in "Add a New Record". But for both job management and job closure I would like the forums to open up direct at the record I am interested in.
On the report I use the ID number for each job (Which is the auto numbering primary key field in the main database). So when I want to do anything with a job I would like to press a button on the switch board, be asked which record I want, and then the form opens up at the correct record.
I kinda figured out I need another form, which is where I enter the job ID number and click a button to action the macro... But I cannot get the macros to work with the "On Click" of the button to take me to the correct form, at the correct record.
Any pointers?
I know I am new to the forum. I registered as I am using MS Access to manage my Repairs and Maintenance jobs at work and need some help.
I use 3 forms, one to record a job, one to manage a job... add comments, purchase order details, that kinda stuff, and a form to close the job.
I also use the switch board to make everything look a bit more swish. Obviously it is fairly easy for the form for adding a job, because switch board manager allows me to open a form in "Add a New Record". But for both job management and job closure I would like the forums to open up direct at the record I am interested in.
On the report I use the ID number for each job (Which is the auto numbering primary key field in the main database). So when I want to do anything with a job I would like to press a button on the switch board, be asked which record I want, and then the form opens up at the correct record.
I kinda figured out I need another form, which is where I enter the job ID number and click a button to action the macro... But I cannot get the macros to work with the "On Click" of the button to take me to the correct form, at the correct record.
Any pointers?