Search results

I'm probably just stupid here Justin but how do you know what "survey types" are available for each "specific pest"?

Thanks Justin. That will help a lot!!

My 2002 system FE/BE has the relationship the same in both FE and BE and I'm certain I only defined those relationships in the BE. At least I'm pretty sure. :eek:

If a Compact and Repair and zipping do not decrease the size enough, it should be possible to create a BackEnd with no data, just the structures. Import just some of the relevant records and then C&R and zip.

It should work just fine. I just wanted to see if there was anything unusual in your environment.

Justin, what version of Access are you using and 32/64 bit?

I might also suggest that 1:1 relationships are not very common. They usually indicate (though not always) fields that should be in the same table.

In looking at your relationship picture, it appears as though you have not defined a relationship for the Protocols table yet.

While I'm giving this some thought I thought I'd point out that it is never a good idea to use a *reserved* word for the name of any object you have defined. In this case you have used NUMBER as the name of a field in the "Pest List" table. Here's a link for you to check a name you might want to...

Hmm...I'm starting to understand your db a bit better. What is the RowSource of the "Select Type" combo box? BTW, I like the looks of your form.

Is there a field in the RecordSource of the mainForm that also appears in the RecordSource of the SubForm that would limit the SubForm to the records you want?

I'm going to assume you are using the LinkMaster/ChildFields properties of the SubFormControl to do your filtering. Are you aware that you can have more than one field listed for each property separated by a ";" ? That may be all you need.

What have you tried so far? What code do you have in the Large Close Button on the Main Form?

You're most welcome and a *BIG* tip of the hat to Doug Steele.

You may need to post your zipped up db for anyone to supply a decent answer.

Perhaps this is what you are looking for: http://www.baldyweb.com/wherecondition.htm

Thanks for that document Pat.

I don't think so unless Stephen Lebans has something: http://www.lebans.com/List_Combo.htm

Where do you want the calculations to go?

Are you familiar with VBA? Have you looked at the DateAdd() function?