Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form / Field Arrays...
I'm not sure if I can do this or not, and I couldn't quite find the solution
here so I thought I'd ask... I have a form with multitab controls for bits of info. There are about 100 or so total fields (some text, some combo, some checkboxes) across the many tabs. I'm using a combobox to select a record from my spreadsheet (there are about 600, and I know ultimately Access would be a better solution but I'm stuck with Excel). I then assign a variable to hold the row number of the record so when we make changes, they can go to the right place. My problem... And I'm no expert here... I'd rather not code each field to get it's value from the master combobox control, nor would I rather code each "After Update" event to store the value. That's a lot of code. And there must be a better way. I have a naming convention for my controls (f000) and they're numbered based on the column they come from, so when I assign my value to, say, f001, it's from row(myCust), column 1. Make sense? What I'd like to do is have any of these f000 fields assigned their value by the myCust row and f000 column, but without having to put that indivdually for each item. ::sigh - I don't even know if that's clear:: Anyone have a good idea to do this? I know I'm probably just having a brain lapse and there's an obvious solution I'm overlooking. Thanks for any help! --jak |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked excel field from access form field - help required. | Excel Programming | |||
Active X Controls Tabbing from Form Field 2 Form Field | Excel Discussion (Misc queries) | |||
Reading Access Form Field and Copy to Excel Field | Excel Programming | |||
Copy form field value to another form (calendar) | Excel Programming | |||
How do I set up excel to tab from field to field in a form? | Excel Discussion (Misc queries) |