C
Carl Rapson
Then your assignment statements should look like this:
Me.1Description = rs.Fields![Description]
Me.1Quantity = rs.Fields![Quantity]
Me.1Total = rs.Fields![Total]
Me.1Invoice = rs.Fields![Invoice]
Me.1Category = rs.Fields![Category]
Does that work?
Carl Rapson
Me.1Description = rs.Fields![Description]
Me.1Quantity = rs.Fields![Quantity]
Me.1Total = rs.Fields![Total]
Me.1Invoice = rs.Fields![Invoice]
Me.1Category = rs.Fields![Category]
Does that work?
Carl Rapson
stephendeloach via AccessMonster.com said:I changed the controlsource different than the name.. maybe this will help?
The names are..
Name ControlSource
Quantity 1Quantity
description 1description
unitprice 1unitprice
taxable 1taxable
total 1total
invoice 1invoice
category 1category
im thinking i dont have it setup right! thanks for your time
Carl said:You say that when you remove those lines it doesn't come up with the
error.
Is the value of the Description field from the recordset actually placed
into the Description field on the form when you do that? If so, then the
only thing I can think of is, once again, that maybe the field and/or
control names aren't correct. What are the names of the controls on the
form
corresponding to each of those fields?
Data types shouldn't matter. The field/control name issue is all I can
think
of based on what you've given me.
Carl Rapson
[quoted text clipped - 40 lines]Private Sub Combo20_AfterUpdate()
Dim rs As DAO.Recordset<snip>