Data Entry

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,

I used your strategy (below) and made two (similar) forms.
Form #1 for view/edit veersion and inserted "AddNew"
button to open form # 2. Form #2 for DATAENTRY.

It looks nice and clear. Howerver, new record, that I
entered in Form #2 (DataEntry),is not updated. It means
that after I closed form #2, I don't see the new record on
Form #1 (View/edit).

Please show me what can I do so that the new record will
add on form #1's record list.

Thank you
Loi

________________________________________-
Reply from You:
One strategy would be to use 2 (similar) forms. One the
view/edit version -
with an "AddNew" button that will open form #2. The
second form will be set
to DataEntry and have a command button to close it. Since
form#1 is still
open ( as it is the only way to open form#2) form#1 will
now display. You
could even make form#2 a pop-up and modal form so that
users get to see it
on top of form#1 and must deal with it before returning to
form#1.
-Ed
________________________________-

Loi wrote at the last post.
 
Use one form and create 2 buttons...keep the "new record"
and add another one with "back to main"

Get rid of your macro for the new record.

go in design mode of form and turn off wizard. Go to the
properties of the form and in the OnOpen section of the
codebuilder type back to main ( or whatever you give the
name to this buton).visible = false

When you close the form after this and open it again, you
wont see the "back to main" button

In the properties of the new record in the OnClick option
type in the codebuilder

DoCmd.GoToRecord , , acNewRec
back to main.visible = true

In the properties of back to main in the OnClick option
type in the codebuilder

DoCmd.ShowAllRecords
 
Back
Top