Newbie is stuck. 4 questions.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. Show multiple row records and show multiple records at the same time.
John Vinson suggested "continuous form view" but I can't discover where to
find that command.
2. Must show lookup fields.
3. Need to be able to adjust space allotted to each record. In design view
now I can't remove the footer to make the record shorter in height.
4. In multiuser mode, I want to allow other users to access the form and
allow them to only add a recod but not edit or delete any previous record.


Sorry to ask so much. I look in books and search the Help files to no
avail. Thanks for your help.
 
I can only answer the first question, u lost me on the others. Questions too
ambiguous, I'm not really sure what u'r asking for.

1. "Continuous form view" is not a command its a property setting. Open the
form, dbl click the form selector in the upper left corner of the form to
open the property setting. Under the format tab, you will find the option
called default view. Using the drop down menu, select continuous forms.
 
i'll take #2.
2. Must show lookup fields.
Click to expand...

first, a small lesson in terminology: *tables have fields, forms have
controls.*
a bound form has a value in its' RecordSource property, and fields listed in
the Field List box. a control on a form can be bound to one of the fields in
the Field List (shows a field name in its' ControlSource property), or
unbound.

if by "lookup field", you mean a combo box control in the form, you can
create one by using the Combo Box Wizard (click on the Wizard button on the
Toolbox toolbar, to select it, then click on the Combo box button on the
same toolbar).

**if you have any "lookup fields" in your TABLE, convert them to normal
fields.** see http://www.mvps.org/access/lookupfields.htm for reasons why.

hth
 
Back
Top