data entry in subform

[Ace9x]

I have a form and subform based on 3 tables built using Form Wizard. The main
form displays the 1st table info (50+ entries) and the subform info from the
2 other other tables in tabular form
Several questions have arisen.

1) In the main form is there any way to allow the user to select an entry
quickly without having to navigate one record at a time through the table?

2) In the subform, when I try to add a new record at the end of the rows
displayed, the columns from the 2nd table allow data entry into them, but any
column from the 3rd table will not accept any data entry. No message is
displayed as to why these columns are not taking any data. As far as I can
see all the relevant properties have been set in the subform to allow this.

Any pointers,ideas gratefully received.

Cheers,
Steve

 

[Gijs Beukenoot]

From Ace9x :

I have a form and subform based on 3 tables built using Form Wizard. The main
form displays the 1st table info (50+ entries) and the subform info from the
2 other other tables in tabular form
Several questions have arisen.

1) In the main form is there any way to allow the user to select an entry
quickly without having to navigate one record at a time through the table?

Many ways... For example, create an unbound combo, add all records from
table1 (for example, ID and name, set column-width to 0 and 2). Then,
on the afterupdate, execute the following code (adjust fieldnames where
applicable):

Dim rsClone As DAO.Recordset
Set rsClone = Me.RecordsetClone
Call rsClone.FindFirst("<fldID>=" & Me.<Comboboxname>.Value)
Me.Bookmark = rsClone.Bookmark
rsClone.Close
Set rsClone = Nothing

2) In the subform, when I try to add a new record at the end of the rows
displayed, the columns from the 2nd table allow data entry into them, but any
column from the 3rd table will not accept any data entry. No message is
displayed as to why these columns are not taking any data. As far as I can
see all the relevant properties have been set in the subform to allow this.

Open the recordset (copy and paste the rowsource into a new query). It
might be not update-able (missing a key for example).

 

[Ace9x]

Gijs,
Thanks for the reply. I have already tried the unbound combo box, but
whenever I try and select a value from it nothing happens.It stays on the
exposed list of entries. I have left the original 4 columns on the main form
and added the Combo at the end and set the controlSource as = [RegisterName].
I created it manually and not using the Wizard, which doesent auto start when
I place a combo box on the form!! I have obviously missed out something else
(I have added the AfterUpdate code on the combo box). Any more
pointers/explanations as to what I've done wrong.
Cheers,
Steve