Design Issue - Best Solution?

A

Ace9x

I would like to create a form based on 2 tables, which, upon entry to the
form is blank and would then allow the user to enter either a code or surname
and return the required record(s) for updating. Entry of data by typing part
of the code/name would be ideal, if not by combo box selection.
If possible the form would also serve to enter new records.

Best suggestions to accomplish this?

I am used to building in Oracle where a simple 'enter query' F7 keystroke
blanks the form and allows entry into fileds including the use of wildcards
and the F8 then populates with all records found.

Cheers,
Steve
 
A

Albert D.Kallal

allows entry into fileds including the use of wildcards
and the F8 then populates with all records found.
Click to expand...

This generally known as "query" by form.

While looking at a form, go records->filter->filter by form

When you do the above, all fields blank, and you can enter search (and wild
cards) into any field.

If you display the tool bar, the you can hit the "funnel" with a form on it.

In many cases, I will actually build a search form. Here is some screen
shots, and some ideas I have on this subject here:

http://www.members.shaw.ca/AlbertKallal/Search/index.html
 
A

Ace9x

Thanks for the reply.

The User only has a run time Access license and I am not sure what toolbars
are made available in this instance, hence the F7/F8 keystroke analogy as a
simple shortcut to providing quick search and find capabilities.
 
A

Albert D.Kallal

Ace9x said:
Thanks for the reply.

The User only has a run time Access license and I am not sure what
toolbars
are made available in this instance, hence the F7/F8 keystroke analogy as
a
simple shortcut to providing quick search and find capabilities.
Click to expand...

Ok, leaving out the runtime detail is a big issue here.

The filter by selection, and the "advanced" filter (that actually launches
the query dialog) DOES work in the runtime. So, you can use those features.

However, the filter by form option does not work in the runtime. The
solution is to simply build a search form for the users. In most cases, not
more then 2-4 fields are required in a search, and thus building a search
form is what I would do here.
 
Top