A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating 2 subforms on a form



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2008, 03:25 PM posted to microsoft.public.access.forms
4charity
external usenet poster
 
Posts: 28
Default Creating 2 subforms on a form

I am trying to create a form that utilizes 2 subforms - one to link toa table
with customer contact info (linked fields - [CustomerID]), the other to link
to a table that keeps track of equipment lent to the customers (linked fields
- [LoanID].) The main form has the [LoanID], as well as the loan date, and
return date. This is based on yet another table.

Problem: the main form and customer contact subform work OK. But, the loan
items subform does not open in the main form. The error message I get is:
"This expression is typed incorrectly, or is too complex to evaluate...Try
simplifying parts of the expression by assigning parts of the expression to
variables."

I am a very simple user of Access - and do not code. I have been able to
make pretty complex programs using only the drag and drop apps and queries.
So please explain to me what, in theory I am doing wrong... like, should this
be based on a query instead of direct tables, or something like that.

Thanks.
  #2  
Old September 10th, 2008, 11:10 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Creating 2 subforms on a form

Hi 4charity,
the loans are related to the customer.
Imagine that you want to show all the loans for a single customer - you
would find all the records in the loans form that have the same CustomerID
as the Main form.
I am assuming that the loans table is related to the customer table via the
customer ID.

If your setup is like I have described above, you could link the second
subform to the main form via the customer ID field.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"4charity" wrote in message
...
I am trying to create a form that utilizes 2 subforms - one to link toa
table
with customer contact info (linked fields - [CustomerID]), the other to
link
to a table that keeps track of equipment lent to the customers (linked
fields
- [LoanID].) The main form has the [LoanID], as well as the loan date, and
return date. This is based on yet another table.

Problem: the main form and customer contact subform work OK. But, the loan
items subform does not open in the main form. The error message I get is:
"This expression is typed incorrectly, or is too complex to evaluate...Try
simplifying parts of the expression by assigning parts of the expression
to
variables."

I am a very simple user of Access - and do not code. I have been able to
make pretty complex programs using only the drag and drop apps and
queries.
So please explain to me what, in theory I am doing wrong... like, should
this
be based on a query instead of direct tables, or something like that.

Thanks.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.