Subform

C

Christina

I have a main form and a subform. Both form properties for data entry is
set to NO, and Cycle...to All Records

The main form contains employee data. The Sub form contains weekly pay
information. I key one employee's pay records, choose another employee
from the main form, and key that person's data. If I then choose the
previous employee in the main form, I cannot see the data in the subform. It
is however in the table, but I would like to see it in the form, and edit if
I need to. When I go back to view, the subform shows a blank form, with
number 1 of 1...blank

I need basic inctructions please.

Thanks
 
R

ruralguy via AccessMonster.com

What do you have in the LinkChild/MasterFields properties of the SubForm
control? Is there a common field in both Employee table and the Pay table?
That is what should be used as the LinkChild/MasterFields. An AutoNumber in
the Employee table as a PrimaryKey and a LongInteger field in the Pay table
as a ForeignKey work the best.
 
C

Christina

The Link Fiefds data type are set to text. It is the employee's ID, and for
our specific purpose can either be a number or a letter, also it cannot be an
auto number. Is the a way that can work?

Thanks
 
R

ruralguy via AccessMonster.com

It can work the way you have it as lonk as both fields are text. Again, you
need to get the pay table set up properly or Access will not ley you relate
the two fields.
The Link Fiefds data type are set to text. It is the employee's ID, and for
our specific purpose can either be a number or a letter, also it cannot be an
auto number. Is the a way that can work?

Thanks
What do you have in the LinkChild/MasterFields properties of the SubForm
control? Is there a common field in both Employee table and the Pay table?
[quoted text clipped - 16 lines]
 
C

Christina

When I choose an employee from the employee records form...which is the main
form, in the subform the same employee shows,up, showing that the fields are
linked. But my problem is as mentioned I am not able to scroll theough all
the pay records for any one employee.
What can be the problem


ruralguy via AccessMonster.com said:
It can work the way you have it as lonk as both fields are text. Again, you
need to get the pay table set up properly or Access will not ley you relate
the two fields.
The Link Fiefds data type are set to text. It is the employee's ID, and for
our specific purpose can either be a number or a letter, also it cannot be an
auto number. Is the a way that can work?

Thanks
What do you have in the LinkChild/MasterFields properties of the SubForm
control? Is there a common field in both Employee table and the Pay table?
[quoted text clipped - 16 lines]
 
G

Gina Whipp

Check...

Allow Additions and Allow Edits making sure they say 'Yes'

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

Christina said:
When I choose an employee from the employee records form...which is the
main
form, in the subform the same employee shows,up, showing that the fields
are
linked. But my problem is as mentioned I am not able to scroll theough
all
the pay records for any one employee.
What can be the problem


ruralguy via AccessMonster.com said:
It can work the way you have it as lonk as both fields are text. Again,
you
need to get the pay table set up properly or Access will not ley you
relate
the two fields.
The Link Fiefds data type are set to text. It is the employee's ID,
and for
our specific purpose can either be a number or a letter, also it cannot
be an
auto number. Is the a way that can work?

Thanks

What do you have in the LinkChild/MasterFields properties of the
SubForm
control? Is there a common field in both Employee table and the Pay
table?
[quoted text clipped - 16 lines]

Thanks
 
R

ruralguy via AccessMonster.com

So you are saying that Pay Records for the Employee show up in the SubForm
but for some reason not all of them?
When I choose an employee from the employee records form...which is the main
form, in the subform the same employee shows,up, showing that the fields are
linked. But my problem is as mentioned I am not able to scroll theough all
the pay records for any one employee.
What can be the problem
It can work the way you have it as lonk as both fields are text. Again, you
need to get the pay table set up properly or Access will not ley you relate
[quoted text clipped - 11 lines]
 
C

Christina

No, actually no records show up, just a blank input form, number 1

ruralguy via AccessMonster.com said:
So you are saying that Pay Records for the Employee show up in the SubForm
but for some reason not all of them?
When I choose an employee from the employee records form...which is the main
form, in the subform the same employee shows,up, showing that the fields are
linked. But my problem is as mentioned I am not able to scroll theough all
the pay records for any one employee.
What can be the problem
It can work the way you have it as lonk as both fields are text. Again, you
need to get the pay table set up properly or Access will not ley you relate
[quoted text clipped - 11 lines]
 
R

ruralguy via AccessMonster.com

Hi Christina,
In a prior post you said that the pay records *did* show up. Is the problem
changing?
No, actually no records show up, just a blank input form, number 1
So you are saying that Pay Records for the Employee show up in the SubForm
but for some reason not all of them?
[quoted text clipped - 10 lines]
 
G

Gina Whipp

What is the LinkMaster/LinkChild fields between the main form and the
subform? Sounds like those are not linking to the correct fields.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

Christina said:
No, actually no records show up, just a blank input form, number 1

ruralguy via AccessMonster.com said:
So you are saying that Pay Records for the Employee show up in the
SubForm
but for some reason not all of them?
When I choose an employee from the employee records form...which is the
main
form, in the subform the same employee shows,up, showing that the fields
are
linked. But my problem is as mentioned I am not able to scroll theough
all
the pay records for any one employee.
What can be the problem

It can work the way you have it as lonk as both fields are text.
Again, you
need to get the pay table set up properly or Access will not ley you
relate
[quoted text clipped - 11 lines]

Thanks
 
C

Christina

Thanks. Checked and it was linking by two fields. Deleted on. Works now.
Thanks so much.

Gina Whipp said:
What is the LinkMaster/LinkChild fields between the main form and the
subform? Sounds like those are not linking to the correct fields.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

Christina said:
No, actually no records show up, just a blank input form, number 1

ruralguy via AccessMonster.com said:
So you are saying that Pay Records for the Employee show up in the
SubForm
but for some reason not all of them?

Christina wrote:
When I choose an employee from the employee records form...which is the
main
form, in the subform the same employee shows,up, showing that the fields
are
linked. But my problem is as mentioned I am not able to scroll theough
all
the pay records for any one employee.
What can be the problem

It can work the way you have it as lonk as both fields are text.
Again, you
need to get the pay table set up properly or Access will not ley you
relate
[quoted text clipped - 11 lines]

Thanks
 
J

John W. Vinson

Thanks. Checked and it was linking by two fields. Deleted on. Works now.
Thanks so much.

<mild grump>

As I asked last Friday (emphasis added):

=====
If that's not it, please post the Recordsource properties of the main and
subform (post the SQL if it's a query), ***and the subform's Master and Child
Link Field properties.***
=====

If you'ld checked it then you could have saved yourself, me, Gina and
rurualguy some time.
 
C

Christina

Sorry but I am not an expert at this, and sometimes I don't really understand
the instructions .

Regrets, Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top