New form with categories...

[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

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

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

Private Sub Combo20_AfterUpdate()
Dim rs As DAO.Recordset

[quoted text clipped - 40 lines]

<snip>

 

[stephendeloach via AccessMonster.com]

I have ended up re-doing the form. I just made a dropdown box in the subform
for the categories... hope it works like I need it to. Thanks for your time.

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

I changed the controlsource different than the name.. maybe this will help?
The names are..

[quoted text clipped - 29 lines]