Form and datasheet

[Guest]

I have a form that contains columnars and a datasheet as subform. The fields
in the columnars are the same as the fields in the datasheet.

When I add a new record in the columnars and click Save button, the new
data will show up in the datasheet as I use "Requery". There is no link
between the columnars and the datasheet.

I am trying to do some code, so that when I click any of the records in the
datasheet, the corresponding record will also show up in the columnars.
Since the columnars are for adding new data, I do not know how to code and
need HELP!!

I have rearranged all the fields in the TAB ORDER, I want some of the
fields excluded in the TAB ORDER and do not know how and need HELP!!

Now, the datasheet will contain the records accumulated. When the
application is close and reopen, the data in the datasheet will be blank.
The datasheet will accumulate records again after users put more records in
the columnars. I do not know how and need HELP!!

Nedd HELP!!!

Best regards,

SC

 

[Guest]

1) TAB STOPS

There is a property Tab Stop (yes/no) on the control whether the control is
included or not in the tab sequence.

2) Columnar and Datasheet I don't really understand your usage for these 2
items
What do you mean by columnar ? Just an entry form? And the datasheet gives
you an overview of existng records?
As far as i can Guess you try to select a record from the datasheet which is
a subform and when it's selected the culumnar(main form) should automatically
reposition to this record.

3) Did you add a condition to the recordsource of your datasheet?

- Raoul