New form with categories...

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
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

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
Private Sub Combo20_AfterUpdate()
Dim rs As DAO.Recordset
[quoted text clipped - 40 lines]
 
S

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.

Carl said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top