FIND/EDIT Commands in VBA CODING

[v_neal]

I have a database that is collecting records for the last several years. On
one form in particular (MAIN ENTRY) I have a subform (ADD VESSEL) which is
launched via a command button. When the (MAIN ENTRY) is open normally, i.e.
one can enter information in the ADD VESSEL subform via the "ADD VESSEL"
command button.
Because updates come in after the entries have already been made in the
database, I created a "FIND ENTRY" command button-which works! However, the
issue is that I can not edit the initial entry once my "FIND ENTRY" button is
used (clicking the ADD VESSEL button only blanks out the screen for half a
second before coming back up with the results of the FIND ENTRY, I have to
scroll through the entire database using the record selectors....at first
this was not an issue, however, I have over 100,000 records and counting.
Is there a bit of VBA code that allows the user to EDIT the entry that I can
add to the VBA?

Thank you all in advance.

 

[John W. Vinson]

I have a database that is collecting records for the last several years. On
one form in particular (MAIN ENTRY) I have a subform (ADD VESSEL) which is
launched via a command button.

So this is an independent, popup form, not actually in a Subform Control...
right?

When the (MAIN ENTRY) is open normally, i.e.
one can enter information in the ADD VESSEL subform via the "ADD VESSEL"
command button.

Just to be sure: it pops up the ADD VESSEL form, you enter the data, close the
form, and go back to the MAIN ENTRY form?

Because updates come in after the entries have already been made in the
database, I created a "FIND ENTRY" command button-which works! However, the
issue is that I can not edit the initial entry once my "FIND ENTRY" button is
used (clicking the ADD VESSEL button only blanks out the screen for half a
second before coming back up with the results of the FIND ENTRY, I have to
scroll through the entire database using the record selectors....at first
this was not an issue, however, I have over 100,000 records and counting.
Is there a bit of VBA code that allows the user to EDIT the entry that I can
add to the VBA?

Please post your existing code. I would guess that you will want to Requery
the MAIN ENTRY form in the AfterUpdate event of the ADD VESSEL form; and
probably use the Combo Box wizard to add a combo box to the main form to
navigate to a selected record. With 100000 rows this will need to be done
carefully! Perhaps you could explain the structure and relationship of your
tables, and the recordsources of the two forms.

 

[v_neal]

So this is an independent, popup form, not actually in a Subform Control...
right?

Actaully, it is still considered a subform even though it comes up as a
"normal" form, when the form comes up, the user has the option of using a
previously registered vessel (which has the information come from a combo
box) or add a new vessel. When the information is complete, to add either a
previous vessel or the new one, one of two command buttons are clicked, "ADD
PREVIOUS" or ADD NEW". When either one is clicked, the form disappears and
the information entered in that subform appears in the MIAN ENTRY form.

Just to be sure: it pops up the ADD VESSEL form, you enter the data, close the
form, and go back to the MAIN ENTRY form?

Yes, that is correct.

Please post your existing code. I would guess that you will want to Requery
the MAIN ENTRY form in the AfterUpdate event of the ADD VESSEL form; and
probably use the Combo Box wizard to add a combo box to the main form to
navigate to a selected record. With 100000 rows this will need to be done
carefully! Perhaps you could explain the structure and relationship of your
tables, and the recordsources of the two forms.

Pretty much, all I want is the VBA coding that does the same thing as
CONTROL +F....and allows wildcards.....that's it. I have very un-savvy
computer operators in my office, though half of them do extol the virtues of
XBOX....

Thank you for responding Mr. Vinson.