Connecting a form with a selection in a multiple form

  • Thread starter Thread starter GIPPI
  • Start date Start date
G

GIPPI

Please, help and if possible don't use abbreviations or acronyms or
take anything for granted: my knowledge of Access is very poor and
English is not my mother tongue.

I have to deal with a large number of clients to be invoiced and would
like not to use a combo for selecting a client, firstly because I find
combos impractical and secondly because the client might not be listed
being a new one.
The following is what I have at the moment:

TABLES: T1 (Clients) and T2 (Invoice), link IDClient
QUERY: Q1 from the 2 tbls
FORMS: F1 (multiple frm with alphabetical buttons sorting names
accordingly, where the client can be selected, and cmdBtn that opens
F2) and F2 (data source: Q1; controls: txtBoxIDClient + others for
data entry in T2).

PROBLEM: The selected client shows on F2, but if he has a previous
invoice, and this is of course what Q1 returns.
QUESTION 1: How do I ask for a new invoice?
QUESTION 2: How do I make a selected new client (ie, with no previous
invoice) show on F2 and then entry invoice data?

Thank you in advance for your help.
 
GIPPI said:
Please, help and if possible don't use abbreviations or acronyms or
take anything for granted: my knowledge of Access is very poor and
English is not my mother tongue.

I have to deal with a large number of clients to be invoiced and would
like not to use a combo for selecting a client, firstly because I find
combos impractical and secondly because the client might not be listed
being a new one.
The following is what I have at the moment:

TABLES: T1 (Clients) and T2 (Invoice), link IDClient
QUERY: Q1 from the 2 tbls
FORMS: F1 (multiple frm with alphabetical buttons sorting names
accordingly, where the client can be selected, and cmdBtn that opens
F2) and F2 (data source: Q1; controls: txtBoxIDClient + others for
data entry in T2).

PROBLEM: The selected client shows on F2, but if he has a previous
invoice, and this is of course what Q1 returns.
QUESTION 1: How do I ask for a new invoice?
QUESTION 2: How do I make a selected new client (ie, with no previous
invoice) show on F2 and then entry invoice data?

Thank you in advance for your help.
Click to expand...
You are wrong about the combo box control. The combo box allows
information to be selected
by point and click reducing data entry errors. Look at the "NotInList"
event. It will allow you to
add code so you can open a form and add new client information and then
return you to your current
form treating the newly added Client as if they existed in the file.

You need to review your design and use a subform for the invoice
records. This way as you
navigate thru the clients in the Main form, Access with refresh the sub
for with the invoices related
the current client. The adding a new invoice will not be a problem. No
second form needed.

How dare you ask us not to use abbreviations or acronyms. What the in
the hell is T1,T2, F1, F2, Q1
combo, cmdBtn?
 
Back
Top