Unbound subfroms or datasheet forms

  • Thread starter Thread starter Rolando
  • Start date Start date
R

Rolando

I'm sorry to bother you guys with probably one of the most obious questions
in Access. but here it goes.

I already see the advantages of working with forms with unbound recordsets,
like adding records, modifying, deleting and so on.

What's bugging me is that I dont know how to apply this principle for forms
showing multiple records. Is there a way to implement adding records via
disconnected recordsets in forms in datasheet view?
I'm I making any sense?
Thank you guys so much in advance for any help on this
 
I'm sorry to bother you guys with probably one of the most obious questions
in Access. but here it goes.

I already see the advantages of working with forms with unbound recordsets,
like adding records, modifying, deleting and so on.

What's bugging me is that I dont know how to apply this principle for forms
showing multiple records. Is there a way to implement adding records via
disconnected recordsets in forms in datasheet view?
I'm I making any sense?
Thank you guys so much in advance for any help on this
Click to expand...

It sounds like you want a data grid on an unbound form. Data grids
look somewhat like the datasheet view. There are a few options:
1) Use a listbox.
2) Use an MSFlexGrid.
3) Buy an after-market grid.
4) Make your own. This offers the greatest level of control (and
promises endless hours of diversion ). Basically, you use
sequentially named labels for the fields of the grid(to create the
rows and columns). You position and make visible a textbox over a
selected label, when editing.
You would need to create scrollbars for navigation. I have posted the
code in previous posts for creating a grid with scrollbars. Do a
search on OldPro and Scrollbars to locate it, if you are interested.
 
Back
Top