Entering records

[Steve]

Hi -
I have a form (Orders) that will be used to enter new job
orders that come in each day. The first field where
information will be entered is the Company Name (combo
box). I've entered 4 new records so far but here is what
is happening. When I go to enter a new record, I select
the Company Name from the combo box and it fills in
correctly into the field but then it sends me back to the
very first record for some reason. Does anyone know why
it is doing this?

Also, when I open this Orders form it opens up to the
first record, I would like it to open up to the next
blank record and still allow me to go back to other
records if need be. Any suggestions?

Thanks for your help.

 

[John Parkinson]

Steve,

Open you form in design view and open the property dialog
box. Under the 'ALL' tab scroll down and find 'allow
edits', 'allow deletions' and turn these off.

Maybe this is what you are looking for.

John

 

[Roxie Aho]

-----Original Message-----
Hi -
I have a form (Orders) that will be used to enter new job
orders that come in each day. The first field where
information will be entered is the Company Name (combo
box). I've entered 4 new records so far but here is what
is happening. When I go to enter a new record, I select
the Company Name from the combo box and it fills in
correctly into the field but then it sends me back to the
very first record for some reason. Does anyone know why
it is doing this?

Also, when I open this Orders form it opens up to the
first record, I would like it to open up to the next
blank record

Open the form in Design view. On the Data Tab in
Properties, select Data Entry = True. This opens the form
to a new record.

and still allow me to go back to other
records if need be. Any suggestions?

Put a Combo Box on your form (I suggest in the Form
footer) that brings up your company list. In the After
Update event, use the following code (with your field and
control names).
Private Sub cboFindRecord_AfterUpdate()
'Allows you to see all the records
Me.DataEntry = False
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me!
[cboFindRecord]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Roxie Aho
roxiea at usinternet.com

 

[Steve]

Hi - This did not seem to work. I still want to be able
to edit and add records to the form, however when
choosing company name from the combo box, it
automatically sends me back to the very first record,
then I have to move forward to the record I was on and
continue entering the info for that record. When I get
to the record I was entering, it kept the company name I
selected. It doesn't seem to be messing with the data
but it just is kind of a pain having to be sent back to
the first record and then having to move forward to the
last record. I have no idea what would be making this
happen - if you think of anything else please let me
know. Thank you.