Search results

Hi Dave, Your example is basically what I'm looking for. CJ, MarkK, and JDraw got me around the code and I think it worked but I can't see my sub-subform. Thank you for showing me the correct syntax for the WITH statement! Working with your subform, I set it to datasheet view, and the...

Hi Mark, Thanks for your insight. I need to see all of the info at once. My main form is address (this is a neighborhood database), my subform is family (this is new, since we are getting multiple families per address), my sub-subform is people (which used to be at the subform level. I need...

Scratching my head… J, then why didn't anything work? I was calling the function from the main form which means the subsubform should have been loaded. Before, I could see the form and subform loaded, but the function bombed on the subsubform. When I can get the subsubform to load, I'll be...

Yay! No error messages but my subsubform won't load so I don't know which fields are visible. I've already posted about this issue in Forms forum. Ya'll rock!

Mark--Much, much clearer and I think it will resolve the issue CJ brought to my attention too. J, I don't have relationships set between my tables but I have queries. I've posted the query underlying subsubform Neighbors. I might actually make head way today!

Lightbulb! Thanks CJ!!! I'm still not clear about your question of 'where' my function is stored. It's in the VBA section of my db. I have it in a Utilities module, so that means outside of the form--right? However, looking over your question--you're right! I'm calling the function from...

Hi J, I'm basically throwing spaghetti at the wall and seeing what sticks. I had to retrofit my original design to accommodate a needed change and nothing's worked since then. My goad is to see all of the people, in all of the families, living in one address. Within those families I have...

Hi Mark, Thanks for you opinion. Would you please dumb it down for me? You're the professor and I'm the student in the back of the class :0

Hi All, I've posted another question to the Forms forum regarding subforms and that led me to trying another solution to my problem. I have a main form, a Family subform, and now a Neighbors subsubform. When I open the main form to test this new design, my Neighbors subsubform doesn't show...

I don't know if this helps are not. This was my latest attempt. I've tried sfrmFamily as both a control and a form. Public Function ControlsVisible() Dim frmNeighborhood As Form Dim sfrmFamily As Form Dim sfrmNeighbors As Control 'Set frmNeighborhood = Forms("Copy of Neighborhood Input...

Hi CJ, I'm using this in an IF statement. Someone suggested I wrap it with a WITH statement. My intended syntax is the control names are within the IF statement so I can set the values depending on whether the person shown is an adult or child: With Forms![Copy of Neighborhood Input...

Hi CJ, I've tried this as well: Forms![Copy of Neighborhood Input Form]!Family.Form!Neighbors.Form and it didn't work. Do I need quotes within the brackets? Thanks

Hi CJ, Thanks, I've been to that link--it seems to be a popular reference. I referred to it trying to solve my problem. I'm using a VBA function so I can call it from different areas on the main and subsubform.

I've tried every variation I can think of and nothing's worked. I posted to the VBA/Module forum.

Hi All, I have code that's not working and decided maybe it's me (and not the code). Based on the result of a combo box on a subsubform (Non child/child), I'd like to show and hide fields. i.e. I'd show an anniversary date for an adult rather than a birth date for a child. This worked when...

I'll give this a go in the morning with fresh eyes (and brain). Thanks!

WITH doesn't seem to be able to handle an ELSE. So if my criteria isn't one, then it's the other. How do I handle that?

I looked up the WITH statement and it is cleaner, however I think I'm still going to have the reference problem. Unless I don't need to declare the form-subform-subsubform.

I haven't tried a WITH construct but I don't think it will take care of my reference problem. Wouldn't a WITH be used in a SQL statement? I'm not familiar with WITH. This is a simple IF THEN ELSE statement showing and hiding fields on a form.

Hello Dave and Galaxiom, This worked before I added the new subform, so I think it's still a reference to the form where the fields are located. I think it has something to do with the setting the variables to objects and then using the object refs in the IF statement. Can you offer any help...