G
Guest
I have been working on a purchase order entry system for several months and
have got things working pretty well except for a a problem I have with a
subform. I have a purchase order entry routine that has two tables -
poheader and poline. The poheader table contains the items common to the PO.
The poline table contains data for each line item on the PO. The two tables
are used in a form called poentry. The subform is poline. In the poheader I
enter data such as vendor information and also enter a po due date and a
material description. These two fields are used as defaults for each line
item and are contained in the poline table. If the user wants to override the
defaults he can do so. When entering data for the poheader we tab through
each field and finally tab to the poline subfrom where tabs are setup to go
first to a line item number. The user then enters the line item number,
usually 1 for the first line item. When the number is entered a line for a
second record opens below the line that is being entered. It contains the
default data of material description and due date. The line where data is
being entered does not display the default data. If I enter a number in the
first field and click escape twice the default fields update and I can
re-enter the line item number in the first (active record) and continue,
othewise the default fields stay blank. The subform is set as continuous with
filters, edits, deletions and additions set as "Yes". Data entry is set as
"No". The defaults are set in the default value property. I have a "New"
button on the form that I use to prepare to enter a new record. The code is:
DoCmd.GoToRecord , , acNewRec
Me.[poorddate].SetFocus
I use this same form to do updates and additions and things work ok. It is
just that first line item entry on a new PO that is a problem.
Can anyone point me in the right direction. I have not found any reference
to a problem like this anywhere.
have got things working pretty well except for a a problem I have with a
subform. I have a purchase order entry routine that has two tables -
poheader and poline. The poheader table contains the items common to the PO.
The poline table contains data for each line item on the PO. The two tables
are used in a form called poentry. The subform is poline. In the poheader I
enter data such as vendor information and also enter a po due date and a
material description. These two fields are used as defaults for each line
item and are contained in the poline table. If the user wants to override the
defaults he can do so. When entering data for the poheader we tab through
each field and finally tab to the poline subfrom where tabs are setup to go
first to a line item number. The user then enters the line item number,
usually 1 for the first line item. When the number is entered a line for a
second record opens below the line that is being entered. It contains the
default data of material description and due date. The line where data is
being entered does not display the default data. If I enter a number in the
first field and click escape twice the default fields update and I can
re-enter the line item number in the first (active record) and continue,
othewise the default fields stay blank. The subform is set as continuous with
filters, edits, deletions and additions set as "Yes". Data entry is set as
"No". The defaults are set in the default value property. I have a "New"
button on the form that I use to prepare to enter a new record. The code is:
DoCmd.GoToRecord , , acNewRec
Me.[poorddate].SetFocus
I use this same form to do updates and additions and things work ok. It is
just that first line item entry on a new PO that is a problem.
Can anyone point me in the right direction. I have not found any reference
to a problem like this anywhere.