Search results for query: *

Thanks to all who replied. I tried them all. I don't understand why, but JaneC's tip of changing the control to a name other than "Business" worked.

Lonnie, why did you ask me to send you my database if you weren't going to respond?

Lonnie Johnson, you got me to send you my database, and then you never responded. that stinks!

I'd be glad to. I'll send it right now.

in those instances where [LName] is blank or null, the business name is showing up as " #error ", instead of listing the name of the business.

Lonnie, Thank you for the quick reply. Unfortunately, when I added the search for blanks, and I still get the same results. Any other ideas?

I am baffled. I'm on a report that comes from a query. I want to only show the [Business] name on my form if there is no agent listed in [LName]. I entered: =Iif(IsNull([LName]),[Business]," ") This works in those instances where [LName] is not Null, but if it IsNull then I get ...

I can't believe it is that difficult. there must be an easier way!

I have a text box on my form that includes the e-mail address for a contact. Can I make a link so that a new e-mail form opens up?

Trying to write a sql statement to return all records from 3 tables, but it is eliminating the records if data is missing from a related table. My statement select * from table 1 table 2 table 3 where table1.idnum=table2.idnum and table2.idnum=table3.idnum. How can I get the data to report for...

I am very frustrated that every time I make a change to a table I have to delete the forms completely and start over. For instance, I used the lookup wizard in one table that looks at values from another table. When I needed to add another record into the table, the new record does not show up...