Don't want to update table

#1

Hi! I'm trying to create a form that allows the user to print a report
based on an identifier that they enter. I created a form with a text
box tied to the table I'm pulling information from and then I
reference the text box in my queries for the report (ie., Form!
Frm_name!Textbox ).
I found that when the form comes up, when the person types the
identifier over the identifier showing, it actually updates that
record in the table with the new identifier.
Can I just change the property of the text box to "unbound" to get
around this problem?

#2

Instead of using a text box - which is obviously attached to the table -
use a listbox - or a combobox. In the listbox the user can scroll to
find the desired identifyer. In a combobox the user can start type part
of the identifyer name and the rest will populdate. You can use the Key
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

#3

On 16 Apr 2009 20:28:00 GMT, Rich P <rpng123 (AT) aol (DOT) com> wrote:

I'm going to disagree with you. A textbox is not neccesarily attached
(bound) to a table: simply set the ControlSource to <blank>.
Otherwise I do agree with you that a dropdown is a good idea because
user has to enter only a few chars to find the report they want to
run, and mouse-centric people are helped as well.
Then the best event to launch the report is not a KeyEnter event
(there is no such thing, though there is an Enter and several Key*
events) but the <control>_AfterUpdate event.

-Tom.
Microsoft Access MVP

Quote:

Instead of using a text box - which is obviously attached to the table -
use a listbox - or a combobox. In the listbox the user can scroll to
find the desired identifyer. In a combobox the user can start type part
of the identifyer name and the rest will populdate. You can use the Key
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

#4

On Apr 17, 12:51*am, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

Quote:

On 16 Apr 2009 20:28:00 GMT, Rich P <rpng... (AT) aol (DOT) com> wrote:

I'm going to disagree with you. A textbox is not neccesarily attached
(bound) to a table: simply set the ControlSource to <blank>.
Otherwise I do agree with you that a dropdown is a good idea because
user has to enter only a few chars to find the report they want to
run, and mouse-centric people are helped as well.
Then the best event to launch the report is not a KeyEnter event
(there is no such thing, though there is an Enter and several Key*
events) but the <control>_AfterUpdate event.

-Tom.
Microsoft Access MVP

Instead of using a text box - which is obviously attached to the table -
use a listbox - or a combobox. *In the listbox the user can scroll to
find the desired identifyer. *In a combobox the user can start type part
of the identifyer name and the rest will populdate. *You can use the Key
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report. *

Rich

*** Sent via Developersdexhttp://www.developersdex.com***- Hide quoted text -

- Show quoted text -

Thanks for the suggestions. I have several reports that I have tied to
text boxes that are generated when clicked. The queries that drive the
reports use the input from the textbox (ie., Form!Frm_name!Textbox).
How do I get the "selected" appropriate value from the combo box to
now populate that textbox or get the query to use the selected item.
Specifically, I have created a query that lists the employee's name
and their employee ID in the combo box. I need the Employee ID in the
queries that my reports use.

David

#5

Dave Moore wrote:

Quote:

On Apr 17, 12:51 am, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

On 16 Apr 2009 20:28:00 GMT, Rich P <rpng... (AT) aol (DOT) com> wrote:

I'm going to disagree with you. A textbox is not neccesarily attached
(bound) to a table: simply set the ControlSource to <blank>.
Otherwise I do agree with you that a dropdown is a good idea because
user has to enter only a few chars to find the report they want to
run, and mouse-centric people are helped as well.
Then the best event to launch the report is not a KeyEnter event
(there is no such thing, though there is an Enter and several Key*
events) but the <control>_AfterUpdate event.

-Tom.
Microsoft Access MVP

Instead of using a text box - which is obviously attached to the table -
use a listbox - or a combobox. In the listbox the user can scroll to
find the desired identifyer. In a combobox the user can start type part
of the identifyer name and the rest will populdate. You can use the Key
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report.

Rich

*** Sent via Developersdexhttp://www.developersdex.com***- Hide quoted text -

- Show quoted text -

Thanks for the suggestions. I have several reports that I have tied to
text boxes that are generated when clicked. The queries that drive the
reports use the input from the textbox (ie., Form!Frm_name!Textbox).
How do I get the "selected" appropriate value from the combo box to
now populate that textbox or get the query to use the selected item.
Specifically, I have created a query that lists the employee's name
and their employee ID in the combo box. I need the Employee ID in the
queries that my reports use.

David

Take a look at the Column property in help.

#6

On Apr 17, 12:04*pm, Salad <o... (AT) vinegar (DOT) com> wrote:

Quote:

Dave Moore wrote:
On Apr 17, 12:51 am, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

On 16 Apr 2009 20:28:00 GMT, Rich P <rpng... (AT) aol (DOT) com> wrote:

I'm going to disagree with you. A textbox is not neccesarily attached
(bound) to a table: simply set the ControlSource to <blank>.
Otherwise I do agree with you that a dropdown is a good idea because
user has to enter only a few chars to find the report they want to
run, and mouse-centric people are helped as well.
Then the best event to launch the report is not a KeyEnter event
(there is no such thing, though there is an Enter and several Key*
events) but the <control>_AfterUpdate event.

-Tom.
Microsoft Access MVP

Instead of using a text box - which is obviously attached to the table-
use a listbox - or a combobox. *In the listbox the user can scroll to
find the desired identifyer. *In a combobox the user can start type part
of the identifyer name and the rest will populdate. *You can use theKey
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report. *

Rich

*** Sent via Developersdexhttp://www.developersdex.com***-Hide quoted text -

- Show quoted text -

Thanks for the suggestions. I have several reports that I have tied to
text boxes that are generated when clicked. The queries that drive the
reports use the input from the textbox (ie., Form!Frm_name!Textbox).
How do I get the "selected" appropriate value from the combo box to
now populate that textbox or get the query to use the selected item.
Specifically, I have created a query that lists the employee's name
and their employee ID in the combo box. I need the Employee ID in the
queries that my reports use.

David

Take a look at the Column property in help.- Hide quoted text -

- Show quoted text -

Thanks to everyone for their comments/advice. It was very helpful. My
form works great (other than I don't understand how to get the combo
box to allow someone to enter another name and select a new person
when they click the mouse in the box - tabbing to the box seems to
solve this problem).

David

#7

Dave Moore wrote:

Quote:

On Apr 17, 12:04 pm, Salad <o... (AT) vinegar (DOT) com> wrote:

Dave Moore wrote:

On Apr 17, 12:51 am, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

On 16 Apr 2009 20:28:00 GMT, Rich P <rpng... (AT) aol (DOT) com> wrote:

I'm going to disagree with you. A textbox is not neccesarily attached
(bound) to a table: simply set the ControlSource to <blank>.
Otherwise I do agree with you that a dropdown is a good idea because
user has to enter only a few chars to find the report they want to
run, and mouse-centric people are helped as well.
Then the best event to launch the report is not a KeyEnter event
(there is no such thing, though there is an Enter and several Key*
events) but the <control>_AfterUpdate event.

-Tom.
Microsoft Access MVP

Instead of using a text box - which is obviously attached to the table -
use a listbox - or a combobox. In the listbox the user can scroll to
find the desired identifyer. In a combobox the user can start type part
of the identifyer name and the rest will populdate. You can use the Key
Enter event to trigger the combobox or click event (for combo or list
boxes) to bring up the desired report.

Rich

*** Sent via Developersdexhttp://www.developersdex.com***-Hide quoted text -

- Show quoted text -

Thanks for the suggestions. I have several reports that I have tied to
text boxes that are generated when clicked. The queries that drive the
reports use the input from the textbox (ie., Form!Frm_name!Textbox).
How do I get the "selected" appropriate value from the combo box to
now populate that textbox or get the query to use the selected item.
Specifically, I have created a query that lists the employee's name
and their employee ID in the combo box. I need the Employee ID in the
queries that my reports use.

David

Take a look at the Column property in help.- Hide quoted text -

- Show quoted text -

Thanks to everyone for their comments/advice. It was very helpful. My
form works great (other than I don't understand how to get the combo
box to allow someone to enter another name and select a new person
when they click the mouse in the box - tabbing to the box seems to
solve this problem).

David

The AfterUpdate event?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Don't want to update table

comp.databases.ms-access comp.databases.ms-access

Don't want to update table - 04-16-2009 , 03:05 PM

Re: Don't want to update table - 04-16-2009 , 03:28 PM

Re: Don't want to update table - 04-16-2009 , 11:51 PM

Re: Don't want to update table - 04-17-2009 , 10:06 AM

Re: Don't want to update table - 04-17-2009 , 11:04 AM

Re: Don't want to update table - 04-17-2009 , 01:28 PM

Re: Don't want to update table - 04-17-2009 , 01:55 PM