Danielle17
Technical User
I need to create a form that when a JobID in a combo box is chosen the rest of the information for that record is displayed in the appropriate text boxes. I then need to be able to make changes to that information. I also have 2 subforms that are related to that same record (through the JobID). They would also need to be changed.
I do have a edit form already created with all the neccesary text boxes and subforms on it. The JobID combo box even works. I have some of the code set up (nothing for the subforms yet) so that it can make the changes. They problem is that when I make a change to a record, the first record in the table is also changed to match the edited record. I have no idea why it's doing this...Maybe it's something simple but so far I'm unable to figure it out. I'll post the code if anyone wants to see it.
p.s. Is there an easy way to create a button that would completely delete a record? I'd like to just type in the JobID number and have that record deleted...
I do have a edit form already created with all the neccesary text boxes and subforms on it. The JobID combo box even works. I have some of the code set up (nothing for the subforms yet) so that it can make the changes. They problem is that when I make a change to a record, the first record in the table is also changed to match the edited record. I have no idea why it's doing this...Maybe it's something simple but so far I'm unable to figure it out. I'll post the code if anyone wants to see it.
p.s. Is there an easy way to create a button that would completely delete a record? I'd like to just type in the JobID number and have that record deleted...
