Register Page based on query ?

G

Gina

Hi.

I would like to get rid of some forms by using a register (sorry ... the
very first time for me)
my form was based on a query and the text controls were referencing fields

so now I copied and pasted them from the form to the register page .... and
now the only thing I see is
#Name?, #Name?, #Name? despite I set them to

=[qry_MaterialVerwendung]![Material]
=[qry_MaterialVerwendung]![Einzelpreis]
=[qry_MaterialVerwendung]![Verwendung]

my cboMaterial doesn't work either as before
I added --> there without any effect
_____________
Private Sub cboMaterial_AfterUpdate()
Dim rs As Object
--> ' Me.RecordSource = "qry_MaterialQuery"
Set rs = Me.Recordset.Clone
rs.FindFirst "[Material] = '" & Me![cboMaterial] & "'"
Me.Bookmark = rs.Bookmark
End Sub
___________

It looks nice this register thing ... but I can't handle it ....
maybe someone could give me a hand ?

Thanks,
Gina
 
Top