Recent content by LisaOnMSN

Appreciate all the effort.

New knowledge is good knowledge. My thanks. Lisa

Would a giant "never mind-I was SO very wrong" be sufficient? I referenced the wrong table in the DLookup: value I was looking for didn't exist in that table (strike one) and I didn't properly test for null (strike two) and since the value I was looking for was in a different table altogether...

Sorry: Read post, ran to mtg, tried to squish before next mtg, had db set to autocompress on close so thought was being done automatically. MAIN form is "frmParkWithTab" SUB form is "frmFeatureWithSubform" SUB SUB form is "frmFeatureSubform" Lisa

I think I took enough out to get it under the requirements...barely. Thank you again for even considering looking at it. Very much appreciated. Lisa

It's pretty huge. Let me try and squish it down to under the 2mg max and get it to you. I would LOVE to let an actual doctor check for the common cold. Give me an hour.

Bob, Paul, thanks for all your help but problem remains (error 2101 or 2467 or....). From what I have seen posted on this and other forums, I'm not alone on having massive headaches trying to swap out sub-sub forms based on sourceobject. Not sure if something gets trashed when the object gets...

Appreciate the info about how to format to display as a code module in a a posting (I didn't know how to do that). I added code to handle possible 'False' return from DLookup and switched back syntax to Me. style. Still getting error, but noticed that my blank default sub sub form (frmBlank) is...

Thanks for your reply. the strFormName variable returns correct info -frmStructure or frmSystem etc depending on the feature. I get error 2101 (I'll attach a screen shot). My db exceeds max size (3.73mb). I can post the routine if that helps? I've changed the things so many times I can't recall...

I reviewed the chart. It appears pretty straightforward. But despite the chart, I have somehow managed to get it to not work properly. At this point I gave up on using what I believed was the right syntax and simply used every iteration listed (whether I thought they reflected the scenario or...

Thanks so much. I'll go read up. Lisa

I have a main form that has a tabbed control on it. The tab control has a Feature tab that loads a generic feature form AND a subform specific to the particular feature type. MAIN FORM frmParkWithTab SUBFORM frmFeatureWithSubform SUB-SUBFORM frmFeatureSubform I use a table that contains 2...

Galaxiom - Too late last night to properly thank you. I was truly stuck on this issue and your reply got me over the wall. Once I got unblocked on this, all I had to do was requery a list on my subform and suddenly everything is synched up, accurate and working. Thank you for replying! Lisa

keyboard got away from me. Main form is frmPark, parkID primary key Subform is frmFeature, featureID primary key, parkID foreign key goal is to return in the listbox on the subform only the features specific to the park that is currently in memory, so the where clause needs to include =...

Thanks so much for replying. MAIN form frmPark SUBform frmParkFeature <-- List box on this subform