Question Continuos form with textbox record??? Another solution???

[Thiago Ortiz]

Dear all,

I'm building a database to control projects of new products for a company, the flow is easy:

-Step 1: Record the general information in a main table (db_master_info) (i.e. project name, description, date of launch, etc.)
- Step 2: Record the product codes in a detail table (db_units) (i.e. product codes and quantities)
-Step 3: Record monthly information like, production and sales forecast in the detail table (db_units)
-Step 4: Build a monthly stock equation(production minus sales forecast) and record a comment, in a comment table (db_comments), about the results.

The steps 1,2,3 and 4 I did successfully!

The step 5, I'm unable to think outside of the box!:banghead::banghead::banghead:

I drew a sketch (form_stock and comments.jpg attached) that might be a possible solution...

Use a continuos subform with a unbound textbox with VBA to load record and edit/update???

How do I do this? Do you see another solution?

Thanks a lot,
Thiago Ortiz

 

[spikepl]

I'd suggest you take a step back, put all the db-lingo aside, and tell us a story about your entities and how they relate. Ennumerated fields are seldom good for anything - your db may be an exception, but that is very unlikely

Oh yeah, and remember to define which bit exactly is "step 5"

 

[Thiago Ortiz]

Hi Spikepl,

I up two images, one is database.jpg, it is the "relationships".

Basically, I record a project (master) and the first sales plan by codes related of the project(child link), linked by projectnumber (autonum), like an invoice order database (northwind.mdb)...

Thereafter, every month I update the sales units of sales and production of each code... (table details; child link).

This data allow creating an equation to control the stocks.

So, I created a form to select a month and generate the stock equation of each project.

After I analyze this equation, is necessary record some comments(memo) about this equation into selected month. (Step5)

So I figured something like the other file attachment. But I am not able to do this: save and load the comment field, every time the combination-month project are chosen.:banghead::banghead::banghead:

 

[spikepl]

I think you overestimate my capabilites to comprehend your business.

If you one month fill out the field m1 and the next month m2 in same record and so on, then your structure need to change - each of these items should be a separate record with a flag telling you what it is, related to a parent record holding the information common to all months. You need to get the structure right before fiddling with forms.

Using only lowercase characters for field and object names is not wise. When you TYPE VBA-code in all lower case then Intellisense converts all reognized names into how they were defined, so if they were defined mixed or upper case, then you can immediately see what did not get converted, and hence is a typo. If they were defined in lower case then you see didley squat.