Using a continuous form for data entry

[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?

 

[Arvin Meyer MVP]

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?

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.

 

[John Spencer MVP]

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

 

[Brian Hoffman]

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!

 

[John Spencer]

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
'====================================================

 

[stevephillips79]

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.




__________________________________________________________

Earn an Extra $1000 to $1200 per month doing Part Time Data Entry Jobs!
Work from home data entry jobs to post simple data submissions on
Internet. Make $1 per entry. Easy form filling, data entry and ad
posting jobs. No selling, No phone calls, No Marketing. No Investment.
Bi-weekly payments. Full Training Provided. Pls visit: ' Data-Entry '
(http://www.dataentrywork.net/?id=26201)


--
stevephillips79
------------------------------------------------------------------------
stevephillips79's Profile: http://www.thecodecage.com/forumz/member.php?u=2392
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=92979

http://www.thecodecage.com/forumz


--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[John W. Vinson]

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.

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]

On Wed, 1 Sep 2010 10:11:23 +0100, stevephillips79

Do you have a question, Steve?

I'm wondering if he posted only to get his sig advirtisement out
there?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[Access Developer]

I'm wondering if he posted only to get his
sig advirtisement out there?

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