Search results for query: *

Thank you so much for your work on this! I will be looking at your recommendations over the next few days and will implement as I'm able. Thanks for pointing out the problems with table lookups - I've never had training in this, so I just made some assumptions about how to develop this...

bump... ;-)

I've uploaded to Google Drive. Here's the link: https://drive.google.com/file/d/0B6UWnUCrVFiBT21sX2lhdUNPbVk/edit?usp=sharing This is the full version of the database, and it's very much a work in progress, so be gentle with the ridiculous design stuff you're sure to find ;-) Take a look at...

IS the idea of running a remote session so you can see what I'm looking at off limits? I'm running Team Viewer 9.0 which is free. You can download it from download.cnet.com if you'd like and I'll allow you a remote view of my machine. Hope that doesn't violate forum rules which I just reviewed...

That's correct... I get the correct query result in the query window when the form is open and I've entered criteria. I managed to remove the error that VBA is throwing by aliasing the reference to Company in the people table as shown below. SELECT Companies.Company_ID, Companies.Company...

OK - so I'm a little closer. I changed People.Company to People.Company AS Business. Now the code doesn't err, the main form returns the correct company name instead of #Name? but the subform doesn't populate... 0_o

Hi MajP - I just looked at the property sheet for the master and subforms and the filter and order by properties are blank. Thanks for the suggestion! Other thoughts? Tom

Hi There - I have a parent form called [/b]Companies[/b] populated by a Companies table and a subform called People_Subform populated by the People table and linked to the parent form via the People_ID primary key. I'm using a toggle button to toggle the recordsource for these forms between...

Hi - I have a form named People connected to a table named People. On that form, there is a combo box named Company that has as its data source this expression to pull values from the Companies table: SELECT [Companies].[Company_ID], [Companies].[Company] FROM Companies; When a Company is...

Thanks so much! It worked first try ;-)

I have a check box control named Primary tied to table field named Primary with a datatype of Yes/No. The check box is part of a form that displays in continuous mode. How do I code so that when the user sets the Primary check box to True that all other records (other than the current record)...