Recent content by ejf071189

(SELECT c_lname, ACCT_No FROM Clients INNER JOIN Accounts ON Clients.c_id = Accounts.ACCT_id)Gave me the following error: So I removed ACCT_no from the code, which resulted in an error saying it could return at most one record. Also, I'd preferably use "Client Name" in place of "c_lname", but...

I have a table of clients and a table of accounts for those clients. Client_Id is a one-many relationship with account_owner. I want to make a query to be used in a mail merge being sent to clients that lists all of their accounts, but in the queries records it just lists a given client's name...

Ok, for whatever reason, the default value for ACCT_owner was set to 0, so that explains why it kept going to 0 in my previous post. But the rest of the problem still stands. In your example, the f11 column doesn't actually get filled until you tab enough to get to the next record, but I can't...

Ok, I tried comparing a little more, and I've almost got it working (I think). When I open the second form from a saved a record of the first form, rather than carrying the key value over, it just puts in "0" every time. Then as I input data, this value never changes and eventually I get an...

Ah, ok, that worked, thank you.

So this would be put under the button's events under "on click"? When I did this, I got an error that "me" was not found as a macro, do I need to create it?

I have a form for filling out client information that has a command button that opens up a spouse information form for that client. The data for both of these forms go to the same table, which is the "clients" table. Since many client's spouses are also clients, it would save alot of time to be...

Thanks for the reply MStef, that seems to be exactly what I'm trying to accomplish. Unfortunately, I'm having a little bit of trouble understanding though. The command button in form1 opens up form2, but behaves like a subform in that the keys are linked. Even though I have my relationships...

Is there a way to create a command button that will open a subform in a new window by default. I do not want the subform to be visible on the main form at any time, and like in most subforms, there is certain data that I want to be automatically sent from the main form into the subform...