Data not showing properly in subform

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a form for software tracking it has a sub form for license information
and one for system the software is assigned to.
When I enter information for license information for one piece of software
it shows up in all of them (same with system but if I get the one to work
then I will be able to get the other to work)

tblsoftware
ID (AutoNum)
Company
Title
MediaType
NumMedia
NumLicense
NumberAssigned

tblLicenseKey
ID (AutoNum) - Primary Key
SWID
LicenseKey
CertiicateNum
OrderNum
ExpDate
NoPerCert

Relationship is one to many tblSoftware [ID] to tblLicenseKeys [SWID]

For some reason when I enter data into the subform it is not getting the ID
from the mainform (can this be done?)
 
Michelle,
Have you entered the Parent and Child property of the subform as...
Parent = ID
Child = SWID
(SWID should be a Numeric Long field)

Even though you may have set up a relationship in the Relationship
window, you still have to call that relationship on your forms with
the Parent/Child.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
That worked...thanks

Al Campagna said:
Michelle,
Have you entered the Parent and Child property of the subform as...
Parent = ID
Child = SWID
(SWID should be a Numeric Long field)

Even though you may have set up a relationship in the Relationship
window, you still have to call that relationship on your forms with
the Parent/Child.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Michelle said:
I have a form for software tracking it has a sub form for license
information
and one for system the software is assigned to.
When I enter information for license information for one piece of software
it shows up in all of them (same with system but if I get the one to work
then I will be able to get the other to work)

tblsoftware
ID (AutoNum)
Company
Title
MediaType
NumMedia
NumLicense
NumberAssigned

tblLicenseKey
ID (AutoNum) - Primary Key
SWID
LicenseKey
CertiicateNum
OrderNum
ExpDate
NoPerCert

Relationship is one to many tblSoftware [ID] to tblLicenseKeys [SWID]

For some reason when I enter data into the subform it is not getting the
ID
from the mainform (can this be done?)
Click to expand...
Click to expand...
 
Back
Top