PhilipEwen
Registered User.
- Local time
- Today, 21:56
- Joined
- Jun 11, 2001
- Messages
- 81
Hi,
Building a client database ( A97 )
When i select a client form opens in datasheet which provides a summary of customer treatments that have occured.
I can then click on a date and it will give me specific details of that treatment.
What i want to be able to do is to add a treatment from the summary form ( incase there are no treatments ) by clicking a button and it will open a data entry form ( different from the summary form ).
This is all fine apart from when you open the form and someone has had treatments, you have to cycle through all the treatments until you get to a blank one - then enter the data.
If I therefore open the form and then via VBA pass the new record command, I of course loose the customer ID number, so the treatment gets added but without customer ID.
How do i therefore open a new form and get it to move to a blank automatically ? I have tried parsing the customer Id by way of a variable after the open form / new record command, but just get the response that I cannot modify the customer Id ( primary key, autonumber )
Am I going about this arse over tit ? is there an easy way ? how would anyone else do this.
Many thanks for any advice.
Building a client database ( A97 )
When i select a client form opens in datasheet which provides a summary of customer treatments that have occured.
I can then click on a date and it will give me specific details of that treatment.
What i want to be able to do is to add a treatment from the summary form ( incase there are no treatments ) by clicking a button and it will open a data entry form ( different from the summary form ).
This is all fine apart from when you open the form and someone has had treatments, you have to cycle through all the treatments until you get to a blank one - then enter the data.
If I therefore open the form and then via VBA pass the new record command, I of course loose the customer ID number, so the treatment gets added but without customer ID.
How do i therefore open a new form and get it to move to a blank automatically ? I have tried parsing the customer Id by way of a variable after the open form / new record command, but just get the response that I cannot modify the customer Id ( primary key, autonumber )
Am I going about this arse over tit ? is there an easy way ? how would anyone else do this.
Many thanks for any advice.
