form not displaying the correct record

[Guest]

I have a database of projects that my company has worked on. On start-up
there's a search form that only allows you to scroll through the records that
are already there but you can niether modify the existing projects or add a
new one on that form. There is, however a button called "edit project" that
brings up another form that allows you to edit the project you were just
looking at in the search form and only that record. On the search form there
is also an "add project" button that again brings up another form but one
that is blank so that you may create a new project.
On both the edit and add forms there's a combo box where the user can select
the client for that particular project. If the client is not present in the
combo box then there's an "Add" button that brings up the 4th form which
allows you to enter all the information about the client, such as company
name, address, client contact, etc. My problem is this: after I enter the
client information in the client form and close the client form, either the
add or edit form (whichever I had been working in) has moved on to a
differernt record. For example, if I was adding a project, after I filled in
the client information and closed the form, that add form is blank again. I
must go back to the search form, find the project I was adding, then click
"edit project" button and then select the client (that I just added) from the
combo box.

If anyone understands what I'm ranting about could you please help me??
Katie

 

[RuralGuy]

See response in line.

I have a database of projects that my company has worked on. On start-up
there's a search form that only allows you to scroll through the records that
are already there but you can niether modify the existing projects or add a
new one on that form. There is, however a button called "edit project" that
brings up another form that allows you to edit the project you were just
looking at in the search form and only that record. On the search form there
is also an "add project" button that again brings up another form but one
that is blank so that you may create a new project.
On both the edit and add forms there's a combo box where the user can select
the client for that particular project. If the client is not present in the
combo box then there's an "Add" button that brings up the 4th form which
allows you to enter all the information about the client, such as company
name, address, client contact, etc.

I'm surprised the system is not using the NotInList event of the ComboBoxes to
add a new Client. In any case, make sure the "4th" form is being involked with
the acDialog parameter to stop all of the code in the calling form.

My problem is this: after I enter the
client information in the client form and close the client form, either the
add or edit form (whichever I had been working in) has moved on to a
differernt record. For example, if I was adding a project, after I filled in
the client information and closed the form, that add form is blank again. I
must go back to the search form, find the project I was adding, then click
"edit project" button and then select the client (that I just added) from the
combo box.

If anyone understands what I'm ranting about could you please help me??
Katie

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.