can I see the Table with its form?

[munger]

I have a form that fills a table. I thought I would make a subform that looks like spreadsheet so that the user can see the previous entries. Perhaps this would prevent a user from reentering data that he forgot was already in the data base.

When I use the subform wizard I am not offered the possibility of the table bound to its own form.

There must be a way to do what I want to do.

Help?

 

[harmmeijer]

You can make some extra fields called previous wich are unbound.
If the form displays the first record the last record will
be displayed in the prefious fields.
Use the following script to fill the prefious fields.

Private Sub Form_Current()
' the query pref wil be made and deleted every current
DoCmd.DeleteObject acQuery, "pref"

Set qdfzoek = CurrentDb.CreateQueryDef("pref", _
"SELECT * FROM address&quot
Set rstresultaat = qdfzoek.OpenRecordset

If Not rstresultaat.EOF Then
rstresultaat.MoveLast
Me.Tekst2 = rstresultaat.street
End If
End Sub

 

[harmmeijer]

I do not exactly understand what you mean by the possibility of the table bound to its own form.
Your form and subform have the same table as datacourse.
Your sub form is only to inform the user so all fields will be locked.

 

[ghubbell]

I think all you really need here is a form who's defaultview is set to continuous forms or datasheet view. If you do set to continuous forms your forms detail height should only be about 1/2 inch tall. Size the form to fit your screen just after designing it but before saving it. This way you'll see as many entries as will fit on your screen.

The main issue here is that you should adjust your tables settings to avoid (not allow) duplicate entries in the appropriate fields. Gord
ghubbell@total.net