 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008forms and sub forms help
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? >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 [quoted text clipped - 7 lines] >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).  SignatureJohn W. Vinson [MVP] 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 > >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 [quoted text clipped - 14 lines] > 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). >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! SignatureJohn W. Vinson [MVP] already tryed thart in datasheet veiw it is still there > >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 [quoted text clipped - 5 lines] > I'm not sure why you would want to; that would make it harder to delete or > copy a record. Your choice though! >already tryed thart in datasheet veiw it is still there Try Continuous Forms view. It gives you more control. SignatureJohn W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.