Tab page

  • Thread starter Thread starter Thomas Wright
  • Start date Start date
T

Thomas Wright

I have a form that uses four tab pages. I'm attempting to populate another
form with the contents of the first page (of the four tabed controls). I'm
finding that the information is not updated reliably when information comes
from the first tab page but does when the information comes from the same
page. Is it reuired to referred to a specific page on the form in the VBA
code?

I'm really new at this,

Tom
 
No, the tab control is not part of the reference to the controls that are on
it. Those controls are considered to be on the main form and can be
reference using Me.ControlName syntax (note no tab control as part of this
reference).

Does the first tab page contain a subform? Give us more information about
what you're trying to do and how.
 
I'm simply attempting to put information from several combobox's into
another automatically through VBA code. The code is typical and simple,

Forms![Residential Patients for DC form]!LaMerNumber = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(0)
Forms![Residential Patients for DC form]!FirstName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(2)
Forms![Residential Patients for DC form]!LastName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(3)

The problem is that the [Residential Patients for DC form] is not always
updated with information. The [Hospital Discharge Information for Each
Patient] form drags information from the [LaMerPatients] table. Patients put
into LaMerPatients table by hand and recently always works whereas much but
not all of the older data put in earlier (imported) does not work reliably.

Does that help?

Tom
 
I wiped out all of the old patient records and at first I thought that was
the problem. I began to have the same problems though with new patient
records. Now the pattern has become that every other patient record is
successful in updating the second box. Is this a refresh problem?

Tom




Thomas Wright said:
I'm simply attempting to put information from several combobox's into
another automatically through VBA code. The code is typical and simple,

Forms![Residential Patients for DC form]!LaMerNumber = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(0)
Forms![Residential Patients for DC form]!FirstName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(2)
Forms![Residential Patients for DC form]!LastName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(3)

The problem is that the [Residential Patients for DC form] is not always
updated with information. The [Hospital Discharge Information for Each
Patient] form drags information from the [LaMerPatients] table. Patients put
into LaMerPatients table by hand and recently always works whereas much but
not all of the older data put in earlier (imported) does not work reliably.

Does that help?

Tom


Ken Snell said:
No, the tab control is not part of the reference to the controls that
Click to expand...
are
Click to expand...
 
May be a code timing problem, but I don't know the process that you're using
to run this code.

Can you delineate the exact steps that you're doing on the first form that
are supposed to cause the second form to get the information from the first
form?

--
Ken Snell
<MS ACCESS MVP>

Thomas Wright said:
I wiped out all of the old patient records and at first I thought that was
the problem. I began to have the same problems though with new patient
records. Now the pattern has become that every other patient record is
successful in updating the second box. Is this a refresh problem?

Tom




Thomas Wright said:
I'm simply attempting to put information from several combobox's into
another automatically through VBA code. The code is typical and simple,

Forms![Residential Patients for DC form]!LaMerNumber = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(0)
Forms![Residential Patients for DC form]!FirstName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(2)
Forms![Residential Patients for DC form]!LastName = Forms![Hospital
Discharge Information for Each Patient].LaMerNumber.Column(3)

The problem is that the [Residential Patients for DC form] is not always
updated with information. The [Hospital Discharge Information for Each
Patient] form drags information from the [LaMerPatients] table. Patients put
into LaMerPatients table by hand and recently always works whereas much but
not all of the older data put in earlier (imported) does not work reliably.

Does that help?

Tom


Ken Snell said:
No, the tab control is not part of the reference to the controls that
Click to expand...
are
on
it. Those controls are considered to be on the main form and can be
reference using Me.ControlName syntax (note no tab control as part of this
reference).

Does the first tab page contain a subform? Give us more information about
what you're trying to do and how.

--
Ken Snell
<MS ACCESS MVP>

I have a form that uses four tab pages. I'm attempting to populate another
form with the contents of the first page (of the four tabed
Click to expand...
controls).
I'm
finding that the information is not updated reliably when information
comes
from the first tab page but does when the information comes from the same
page. Is it reuired to referred to a specific page on the form in
Click to expand...
the
VBA
code?

I'm really new at this,

Tom
Click to expand...
Click to expand...
Click to expand...
 
Back
Top