forms and sub forms help

[Steve]

I have a form with a sub form on it the sub form is in Datasheet view this is
a 1 to many arrangement. The 1 being the main form and the many being the sub
form.
The sub form is the one in Datasheet view.
Normally the line for the new entry of a records is at the bottom of the
Datasheet view form and all the items listed/found for this main item are at
the top of the sub form.

Is it possible to revers this eg flip the form up side down and have the
line for the new entry at the top of the list/form and then list all the
listed or found items from there down?

 

[John W. Vinson]

I have a form with a sub form on it the sub form is in Datasheet view this is
a 1 to many arrangement. The 1 being the main form and the many being the sub
form.
The sub form is the one in Datasheet view.
Normally the line for the new entry of a records is at the bottom of the
Datasheet view form and all the items listed/found for this main item are at
the top of the sub form.

Is it possible to revers this eg flip the form up side down and have the
line for the new entry at the top of the list/form and then list all the
listed or found items from there down?

Not directly - but you can fake it using two subforms. Use one subform for the
data entry, with its Data Entry property set to Yes (so it lets you enter new
records but not edit existing ones); below it put a second subform, of
identical structure, with Allow Additions set to No, to display existing
records. You can set this second subform's Allow Edits property to Yes or No
as you prefer (you might want to lock existing records from editing).

 

[Steve]

thanks for that i have tryed it with 2 forms and a form and a list box i
think the list box works a bit better but i cannot get rid of thr recored
indecator on the left hand side of the form any sugestions.
i have seen this dodn in MYOB retail manager using Access 95

 

[John W. Vinson]

thanks for that i have tryed it with 2 forms and a form and a list box i
think the list box works a bit better but i cannot get rid of thr recored
indecator on the left hand side of the form any sugestions.

Open the form in design view. View its Properties; set the "Record Selectors"
property to No.

I'm not sure why you would want to; that would make it harder to delete or
copy a record. Your choice though!

 

[Steve]

already tryed thart in datasheet veiw it is still there

 

[John W. Vinson]

already tryed thart in datasheet veiw it is still there

Try Continuous Forms view. It gives you more control.