bloody_football
Registered User.
- Local time
- Tomorrow, 02:52
- Joined
- Sep 8, 2004
- Messages
- 70
I have created this database for work and it is my first go. I have a few bugs that need to be sorted out before it is finished.
A) When creating a quote in the 'FORM - Quote' the autonumber will not activate when something is entered into any field - it simply goes blank. the only acception is in question 'B' below. NOTE that I can get the autonumber to work if I had one table but this is a combination of 2 tables.
B) If a sales person is chosen then the autonumber is activated, but when I click 'hire quote' the number is not taken to the next form.
C) When I click on 'hire quote' the quote is not saved, I suspect this is because I have no ID number. In the 'Event Procedure' I have tried to save the record by
and also by INSERT each piece of information into it's respective tables.
A) When creating a quote in the 'FORM - Quote' the autonumber will not activate when something is entered into any field - it simply goes blank. the only acception is in question 'B' below. NOTE that I can get the autonumber to work if I had one table but this is a combination of 2 tables.
B) If a sales person is chosen then the autonumber is activated, but when I click 'hire quote' the number is not taken to the next form.
C) When I click on 'hire quote' the quote is not saved, I suspect this is because I have no ID number. In the 'Event Procedure' I have tried to save the record by
Code:
DoCmd.RunCommand acCmdSaveRecord
