Search results

It looks like this cmbo.jpg and yes i have a lookup field at the table level, it seemed to provide what I needed at the time. I just need a way of having my search textbox and combo boxes filter the datasheet.

I edited my previous post regarding the link fix. I've been working on it all morning and came to the realizations you made. The 3 tables were lookup tables (Classification, Industry Coverage, and Geographical Focus) and used the lookup wizard which created the relationships automatically...

You're right, I went ahead and created tables for all three of the combos (Classification, Industry, and Geographical) along with relationships and re-insert them as a combo box and two list boxes (since one firm can cover more than one industry or region) appropriately across my forms. I was...

I'm trying to figure out how I can filter the datasheet on my split form by use of a search box and 3 combo boxes. I'd like each record in the combo box to appear just once, even though they're not unique to any one firm, maybe by making a table for each? Lastly under the "More Info" column i'd...

Re: Trying to figure out how to duplicated template layout I fixed it

I'm an Access newb and iv'e been trying to develop an investor database. I was looking at some of the templates offered by Access and I really like the "Contact Management Database" which seems to fit exactly what i'm going for. " 1zqrm.jpg" Can anyone help me figure out how they...

I'm running an Access 2003 database and nothing was altered over the weekend, but when I open it up today and run a report, several records are missing from the report. The records show up just fine on the form search, but I have no idea why they're not showing up now on the report. Anyone have...