Dynamically add controls in MSAccess Forms

  • Thread starter Thread starter sunil T via AccessMonster.com
  • Start date Start date
S

sunil T via AccessMonster.com

Hi,

i have a form with around 40 text fields.in the end of that form i have to
get modification history for the particular product ...(it may vary for each
product ..may be 5 times for one product or may be 2 for another product )
from the user.Is any way to capture those user inputs by dynamically creating

the text box for each modification history??? ( i know how to do it in VB
6.0)..but am not very sure about the MS-Access...is it possible in
MS-Access???


**** IS ANY OTHER WAY TO CAPTURE THOSE INPUTS ..LIKE GRID OR
SOMETHING**********
pls help me ...

thanx in advance...

with regards

Sunil
 
While what you're describing can be done using the CreateControl method,
it's usually not advised.

From a database design perspective, your modification history should be in a
separate table than the product details, with a 1 to many relationship
between the two tables. Create a form that shows details from the history
table, and use that form as a subform on the many form, with the two forms
linked by the product id.

For an example, look at the Orders and Orders Subform in the Northwind
database that came with Access.
 
Back
Top