Linking Fields in form to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that when you click the button it goes into a query. It asks for the store #. You type it in and it pulls the store information from the job site table into the form. There is a subform that I created within that form that pulls 3 fields from the query and keeps it when I go to add a new record to that store. How can I link MORE than 3 fields to that subform and keep it, cause when you create a subform it only allows you 3 linking fields? Does anybody know the SQL language or the behind the scenes way to do that? I REALLY need this to work for invoicing report purposes.

Thanks!
 
not sure what you are specifically trying to do, but I would add a textbox
to my form that strings together the data and link off that. For example:

=[BillCenter]&[GLAcct]&[CustNumb]&[InvNumb]&[PartNumb]

If your sub form is based on a query, you would need a similar string to use
as your link. Such as:

LinkData: [BillCenter]&[GLAcct]&[CustNumb]&[InvNumb]&[PartNumb]



Post more details if this does not get you on the right path.

Rick


MaryR said:
I have a form that when you click the button it goes into a query. It
Click to expand...
asks for the store #. You type it in and it pulls the store information
from the job site table into the form. There is a subform that I created
within that form that pulls 3 fields from the query and keeps it when I go
to add a new record to that store. How can I link MORE than 3 fields to
that subform and keep it, cause when you create a subform it only allows you
3 linking fields? Does anybody know the SQL language or the behind the
scenes way to do that? I REALLY need this to work for invoicing report
purposes.
 
Back
Top