Can someone point me in the right direction to accomplish the foll

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone point me in the right direction to accomplish the following.. I
want to add a subform (I think this is what i need??) to another existing
form. The subform needs to include a listbox (only to include 1 combo box
and 1 text box). The combo box (account #) values will come from a table
field and the text box is an amount ($$) field.. that the user enters in.
The user may have as many records (accts/amts) as necessary. After the first
combo box value is selected i would like the next line/record to appear
(cursor to go to the next line and where the user can enter another
account/amt).. I've been getting no where with this.. anyone have advice?
thanks.
 
NOT DOUBLE-POSTED.. BUT A TOTAL OF 5 TIMES.. SORRY.. I KEPT GETTING THE ERROR
THAT MY POST WASN'T SUCCESSFUL.
 
NOT DOUBLE-POSTED.. BUT A TOTAL OF 5 TIMES.. SORRY.. I KEPT GETTING THE ERROR
THAT MY POST WASN'T SUCCESSFUL.
Click to expand...

Not your fault. It's a bogus error message, one of many reasons a lot
of use really dislike the web interface, and instead use newsreaders
such as Outlook Express or Agent.

I'n not sure what you mean. You want a combo box INSIDE a listbox?
Can't happen. I think what you want is a Continuous Subform - with
textboxes, combo boxex, listboxes, or whatever other controls (except
another subform, which aren't allowed in continuous forms).

Just create a Subform using the subform wizard; select the form you're
using as the subform in design view. Change its Default View property
from Datasheet to Continuous and you'll see as many lines as you have
room for on the form.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top