Form question and autofilling combo box

[nobbie1]

I have a small db I'm working on for my boss. A side project I thought I'd attempt to in order to familarize myself with Access and databases in general I think I've got some fo the basics down.

My question is this. I have a form which I want to be able to use for data entry. I don't want to see the different little record bar sliders on this form. Is there a way to get rid of them?

Also I want to be able to have it so that with my one combo box, if they select their last name, the form will autopopulate the first name box with their first name.

I don't have any deadline on this, since I was doing it of my own free will But any help would be appriciated. Thanks

 

[WayneRyan]

nobbie,

To get rid of the "slide bars" get your form in the design view.

Right-click on the mouse and select Properties.

Left-click on the upper-left hand of the form, you will see a
little black square. The properties box will say form.

Choose the format tab, near the top it says scroll bars - choose
neither.

For the second topic:

The rowsource for the combo should be:

Select LastName, FirstName From YourTable Order by Lastname;

The combo box has no control-source, it is not linked to your
table.

In the AfterUpdate event of the combo, put:

Me.FirstName = Me.cboNames.Column(1)

Wayne

 

[nobbie1]

Thanks Wayne,

The slider bars I don't want showing are the ones to choose different records. Is there a way that the form can only be set to enter in new data? The users won't have a reason to go back to a previous date to change things. I think I"m pretty close to being finished with the layout of how I want this to work.

Thanks again

 

[WayneRyan]

nobbie,

Set the form's data entry property to YES.

Wayne