Search Form / Data Entry Form

[Rosemary]

Hello,

Our database has one main form that we use to view our
data. This main form has several subforms.

Now I'd like to have one version of the form that is used
for searches only (no editing capability), and one
version of the form that is used for data entry.

Do I need to separate forms for searching and data entry,
each with its own set of subforms?

Thanks,

 

[goofy]

Not certain what you are asking. You can design similar forms for
entry and search, but whether or not they are the same, or separate,
is a matter of choice. It is easier to implement a stand alone search
form, but here is an idea for a combo:
In a section of the data entry form you have a text box. This is where
you enter the search item. A button next to it should run a query and
then refresh the form. A list box below the text box is filled in with
data from the query I just mentioned. The list box should be enabled,
but with data locked to allow scrolling, but no changes.

A word of caution, it is possible the above will allow partial entries if
you are not careful. That is, if the user is part way through an entry
when they use the search function, part of the changes could be lost.
For this reason, I use stand alone search forms, but allow them to
always be visible.

Scott