RitaMoloney
Registered User.
- Local time
- Yesterday, 21:16
- Joined
- May 6, 2004
- Messages
- 50
Hello,
On my form, when adding a new record I select Job Name form a combo box, which creates a new record for the Job Details table.
On the Subform, the Job Details ID creates a new record for the parts used table.
It will allow me to save that record once.
I need to be able to select more than one part used for the same job. i.e. create a new record on my subform while keeping the same Job Details ID number.
I am sure this has to be done through a command button and some vb attached to it. I have no idea how to go about it and would really appreciate it if someone could help. I have attached a picture of my form. If you need more details please let me know.
Thanks in advance,
Rita
On my form, when adding a new record I select Job Name form a combo box, which creates a new record for the Job Details table.
On the Subform, the Job Details ID creates a new record for the parts used table.
It will allow me to save that record once.
I need to be able to select more than one part used for the same job. i.e. create a new record on my subform while keeping the same Job Details ID number.
I am sure this has to be done through a command button and some vb attached to it. I have no idea how to go about it and would really appreciate it if someone could help. I have attached a picture of my form. If you need more details please let me know.
Thanks in advance,
Rita