Using a continuous form for data entry

  • Thread starter Thread starter Brian Hoffman
  • Start date Start date
B

Brian Hoffman

Does anyone know of issues with using an unbound control on a continuous data
entry form?

I am using a "pop-up" "continuous" form for "data entry" into a link table.
The PK is an auto#. FK1 self-populates by looking at the parent form. FK2 is
selected using a combo box. There is also an unbound combo box used simply to
filter the cbo used for FK2.

The issue: (As I said this is a "continuous" "data entry" form) The user
first makes a selection in the unbound cbo. This filters the row-source of
the cbo used for FK2. Once the user makes a selection in the second cbo the
record is entered and a new one is created. However, the unbound cbo of the
new record is populating itself with the same selection i just made for the
previous record. Why does this happen?
 
Brian Hoffman said:
Does anyone know of issues with using an unbound control on a continuous
data
entry form?

I am using a "pop-up" "continuous" form for "data entry" into a link
table.
The PK is an auto#. FK1 self-populates by looking at the parent form. FK2
is
selected using a combo box. There is also an unbound combo box used simply
to
filter the cbo used for FK2.

The issue: (As I said this is a "continuous" "data entry" form) The user
first makes a selection in the unbound cbo. This filters the row-source of
the cbo used for FK2. Once the user makes a selection in the second cbo
the
record is entered and a new one is created. However, the unbound cbo of
the
new record is populating itself with the same selection i just made for
the
previous record. Why does this happen?
Click to expand...

Because it is unbound to a field. If the form was not continuous, it would
still happen. Change the form temporarily to Single Form View, and use the
combo. Now move to the next record. Notice the combo selection is still
there.
 
UNBOUND controls have ONE value and only one value. What you see on the
screen is multiple images of that one control that all display that one value.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Arvin, John,

Thank you both very much. I have used this method several times in Single
Form view. I suppose I just didn't think this one through haha.

Just a follow up question...Can I write a simple piece of code and attach it
to an event so the unbound cbo will refresh on a new record? If so, which
event would be proper for such a procedure?

Again, I appreciate you're help very much!
 
You could use the current event of the form and code like

Me.NameOfCombobox.requery

to make the list of items refresh every time you move to a new record.
That will then show null as the current value.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
hi,
Have a data entry form that I use to enter work times. .... And of
course as you know, when using continuous forms,Made a data entry form
which is a subform. I made a continuous form that displays ... I'm using
2 forms one is a customer entry form.
Click to expand...

Do you have a question, Steve?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Tony Toews said:
I'm wondering if he posted only to get his
sig advirtisement out there?
Click to expand...

I do hope no one reading this newsgroup is naive enough to respond to a
solicitation for "work at home data entry" from an unknown source. I think
"data entry" rates right up there with "stuffing envelopes", "assemble
product from our parts kits", and "pyramid schemes" in the old "make big
money working at home" scam Hall of Fame.

Larry Linson
Microsoft Office Access MVP
 
Back
Top