Recent content by LisaRae007

I am dealing with a situation with this same error....but in Access 2010. I can't seem to find a way to get the database to open in shared mode. Even without placing anything in edit mode, we get this error. The database is on a network folder. I looked how to split the database as you...

Thanks for reading and considering my question! I have two tables: ValidAddresses Restaurants The valid address table contains precise location information, with a separate field for each component of the address: number, streetname, streetsuf, city, zipcode and parcelnumber. Because I am...

Obviously, judging by your reaction, you have placed a lot of value in your post rank. You shouldn't talk down to people though. The only reason people come to the forum is to get help and find answers. I know, you have lots of postings in other portions of this site. And yes, I did look you...

Good point. I realized afterwards that it was old. I suppose me putting that out there was almost as useful as posting a question like yours. Goes back to the old expression, "why ask why?". I guess maybe rhetorical question postings are a good way to get 10K postings out there. I have seen...

Not to confuse matters, but I am wondering if your database would be more powerful and flexible for future uses of the data if you used some of the relational perks of using the db rather than excel. For example, have a table of doctors, a table of locations, and a table in the middle somewhere...

That worked! Thanks for the input. I ended up with a... Me!ChemicalTestSubform.Form!WaterUnitLkup.Requery [Me!Subform1.Form!ControlName.Requery] ...in the OnCurrent of my main form. So far it looks like it is doing what I wanted. Thanks again.

It didn't work...I went back and read more carefully and noticed a difference between the original user's question and mine. I have my form set up as "single form" instead of "continuous form". Would this change your approach or explain why your suggestion didn't work? I'm going to continue to...

combo box requery on subform This was from 2002, I realize, but I came across your helps to the other user and realize that it is exactly what I am struggling with as well. I couldn't find the sample you put out as possible solution. Is it still available? I need a combo box on a subform to...