Table to Form

  • Thread starter Thread starter Ted Cummings
  • Start date Start date
T

Ted Cummings

Hi,
Is there any way I can select a specific record in Table view
and automatically have the Form view open at the same record?
TIA.
 
Ted,

Most everyone here will tell you (and I concur) to never use an actual table
view for your user interface. Create a form that gives a table-like view and
go from there.

The reasons for this are many - but the most important one to you right now
is that forms provide a lot more power and flexibility.

Here are the basic steps.

1. Create a new form that shows your data in a datasheet view. There's a
form wizard that will walk you through that. This will actually become
what's called a sub-form.
2. Close the form you just made.
3. Create a new blank form with no table or query for the data source.
4. Drag the first form into the new form design window leaving a little
space at the top and save it.
5. Click form view.

You should see a form with the datasheet view in the lower portion of the
form.

Now you can really start doing what you wanted. If you make it through these
steps and want more help reply to this and we'll give it a shot.

HTH

Earl Lewis
 
Hi Earl,
Many thanks for your help, this is the sort of reply I was
looking for.
Ted
 
Back
Top