Name in table changes

  • Thread starter Thread starter nancy
  • Start date Start date
N

nancy

Name in table changes when making a change to a different name on a form

This is how I set up a switch board and form


Switchboard
Combo box: lists last names of clients. Row Source is linked to a name query

Button to open a form based on the last name selected in the combo box.
On click: it opens a form that contains client information.
The command for the button is;
Participants1, Form, , [P Last Name]=[Forms]![Switchboard]![CombLast Name],
Edit, Normal
Command – Form name - Participants1
- View - Form
- Where condition – [P Last Name]=[Forms]![Switchboard]![CombLast Name]
- Data mode – Edit
- Window mode – normal
-
The name query is linked to a table called “Participantsâ€.

The form “participants1†is opened to the name that was chosen in the combo
box
The participant form is linked to a table called “Participantsâ€
I need to do editing to the client information.
Since the form is still under construction. I will get into design view and
make changes to the form.

When I close the form for some reason the last name of a different person in
the table will change to the name that was selected.

Is there something I need to change to prevent this.
 
nancy said:
Name in table changes when making a change to a different name on a form

This is how I set up a switch board and form


Switchboard
Combo box: lists last names of clients. Row Source is linked to a name
query

Button to open a form based on the last name selected in the combo box.
On click: it opens a form that contains client information.
The command for the button is;
Participants1, Form, , [P Last Name]=[Forms]![Switchboard]![CombLast
Name],
Edit, Normal
Command – Form name - Participants1
- View - Form
- Where condition – [P Last Name]=[Forms]![Switchboard]![CombLast Name]
- Data mode – Edit
- Window mode – normal
-
The name query is linked to a table called “Participantsâ€.

The form “participants1†is opened to the name that was chosen in the
combo
box
The participant form is linked to a table called “Participantsâ€
I need to do editing to the client information.
Since the form is still under construction. I will get into design view
and
make changes to the form.

When I close the form for some reason the last name of a different person
in
the table will change to the name that was selected.

Is there something I need to change to prevent this.
Click to expand...


Is your Switchboard by any chance a bound form, maybe with the Participants
table as its RecordSource, and the combo box on it bound to the [Last
Name[ field in that table? If so, every time you select a name in the combo
box, you'll be changing someone's name. A switchboard form will normally be
unbound, and a combo box used to select an individual to open a detail form
will also be unbound.
 
I unbound the switch board and the combo box. Now it will not allow me to
pull the names I want inorder to open the form to the name I chose.

How do I get it to work w/o changing the names.

Nancy

Dirk Goldgar said:
nancy said:
Name in table changes when making a change to a different name on a form

This is how I set up a switch board and form


Switchboard
Combo box: lists last names of clients. Row Source is linked to a name
query

Button to open a form based on the last name selected in the combo box.
On click: it opens a form that contains client information.
The command for the button is;
Participants1, Form, , [P Last Name]=[Forms]![Switchboard]![CombLast
Name],
Edit, Normal
Command – Form name - Participants1
- View - Form
- Where condition – [P Last Name]=[Forms]![Switchboard]![CombLast Name]
- Data mode – Edit
- Window mode – normal
-
The name query is linked to a table called “Participantsâ€.

The form “participants1†is opened to the name that was chosen in the
combo
box
The participant form is linked to a table called “Participantsâ€
I need to do editing to the client information.
Since the form is still under construction. I will get into design view
and
make changes to the form.

When I close the form for some reason the last name of a different person
in
the table will change to the name that was selected.

Is there something I need to change to prevent this.
Click to expand...


Is your Switchboard by any chance a bound form, maybe with the Participants
table as its RecordSource, and the combo box on it bound to the [Last
Name[ field in that table? If so, every time you select a name in the combo
box, you'll be changing someone's name. A switchboard form will normally be
unbound, and a combo box used to select an individual to open a detail form
will also be unbound.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
nancy said:
I am now able to have the combo box choose the name.
When I click the button, it is bring up the form with the first person in
the table, not the person I selected.

I think some thing is wrong with my macro.


Participants1, Form, , [Forms]![Switchboard]![CombLast Name], Edit, Normal
Click to expand...


If you are trying to apply criteria to the [Last Name] field on the
Participants1 form, then your macro's Where Condition argument should say
so:

[Last Name]=[Forms]![Switchboard]![CombLast Name]
 
Back
Top