Just ask if you need clarification!
Search as I type
- Thread starter Cindy
- Start date
many thanks to you, vbaInet and the others who've helped me thus far. I hope to improve on my Access programming and contribute to this site as well
however I double clicked on a record but nothing happened. I tried to see if there was a double click event which can be programmed but I didn't see any. could you clarify this please?
however I double clicked on a record but nothing happened. I tried to see if there was a double click event which can be programmed but I didn't see any. could you clarify this please?
yes vbaInet I didn't even know I hadn't understood I unfortunately didn't have a good grounding in VB programming class. However I'm encouraged to pick up "VB for dummies" and start afresh. Your help is much, much appreciated.
I unfortunately didn't have a good grounding in VB programming class. However I'm encouraged to pick up "VB for dummies" and start afresh. Your help is much, much appreciated.Maybe you'll be teaching me instead when that time comesI hope to improve on my Access programming and contribute to this site as well
CJ, I didn't understand the double-click part that Cindy is talking about as well. What should be happening?
- Local time
- Today, 14:17
- Joined
- Feb 19, 2013
- Messages
- 17,762
double clicking on a row in the subform list in the header section opens the relevant record in the main form.
Although I had written the code, I hadn't assigned it to the double click events for the controls.:banghead:
okay back to the same old question. In the subform/subreport, how can I get the TripID and PatientID controls to be at the front and not behind?!
Please see what I mean in the attached file, the first image was created by CJ London
Please see what I mean in the attached file, the first image was created by CJ London
You misunderstand the use of a subform. A subform is a container a form, not just for controls.
If you look at CJ's example he's created a form and then he's used the subform control to house the form which houses controls.
If you look at CJ's example he's created a form and then he's used the subform control to house the form which houses controls.
um, apologies if this is not a bright question. In creating the subform, I referenced the obstetrics table and the subform was created with some of its fields but how do I get it to lift data from obstetrics? I imagine that as the database grows, I'd want the subform to dynamically adjust itself since the filter is applied to the subform?
It's doing that already. The data you see is being pulled from the Obstetrics table.
With reference to creating a subform, the best thing to do is to create a form based on the Obstetrics table or query (preferred), save the form. Then drop a subform control and reference the form you just created. That way, if you need to make design changes (or whatever else) you can open the form itself and make the changes.
With reference to creating a subform, the best thing to do is to create a form based on the Obstetrics table or query (preferred), save the form. Then drop a subform control and reference the form you just created. That way, if you need to make design changes (or whatever else) you can open the form itself and make the changes.
Okay I think I got confused because in my Access what I have is the combined subform/subreport icon. Apparently the subform container is already applied at the end of the creation but I was still trying to get the separate subform icon to act as a container.
my subform is populated with the data now. Thank you very much.
PS: I will start a new thread next time
my subform is populated with the data now. Thank you very much.
PS: I will start a new thread next time
