Search results for query: *

Eureaka! I found what I was looking for in faq702-410. Oddly enough, it was the .jpg file that solved the problem! Sometimes a new perspective is all you need! Thanks for all your help, norwood and DougP! I'm sure that I'll be back on Monday with a new set of problems, but that's life!

I've done a slight redesign of the db. Now the data in subform C is part of the same record that is subform B. Problem is that I need the record in subform C to change whenever I switch the record on subform B. Currently, subform C appears to be independent of Subform B, but changes when I...

Sorry, Norwood, but I'd be lucky if I was drawn and quartered if I did that. The client won't even allow a blank version of the db to leave the premesis! I did solve that portion of the problem. I just did it with two queries: Subform B: SELECT DISTINCTROW PolicyTable.ClientNumber, ...

I've now attached both to the same query, but the problem is that I need Subform C to display a subset of Subform B. It needs to show the data for whichever record in Subform B is currently selected.

Thanx for your response, Norwood. The problem I'm having is that the that I need to bind Subform C to Subform B. Access is telling me that the Subform C is unbound and I can't figure out how to bind it.

I need a way to display a subform based on the active record in another subform. The setup is as follows Form A Contains Groups. SubForm B Contains Members of each group. SubForm C Contains Details of the selected member. Any help would be greatly appreciated.

Thanx...I needed that! I got caught with 'forest for trees syndrome'! I've changed the design to having only one table and everything works! (I inherited this db, so I assumed that there was a good reason for the structure...there wasn't! Again, LittleSmudge, I thank you!

This is probably a very easy thing to do, but I'm very new to access and I'm under the gun here, so I apolgize for asking a question that is problably posted in a faq somewhere. I have a database that is set up as follows: I am using Access 97. I have 3 tables linked by a primary key. The...

FancyPrairie, I think you hit the nail on the head! I tried running the subform and my code behaves as expected...Now all I have to do is figure a way around the problem. Unfortunately, I don't have the option of creating a filter form...The user community would freak!

I'm having the same problem...I noticed that there has been no response to this post in over a year, but hopefully someone has the answer. The search works occassionally, but 80% of the time, it doesn't. While I'm not very familiar with Access, I am computer literate, so I can follow a...