how can i repeat selected fields on an access 2007 form

  • Thread starter Thread starter dann
  • Start date Start date
D

dann

i am trying to create a BOM datta entry form using access 2007. I have one
table. i would like to repeat the drawing number, description, issue date
type fields as i add new records without re-typing.


thanks for your help
 
Why not use a subform to enter non-repeating data?

Have one-to-many something like this --
Project
Drawing
Material
Set relationship for one-to-many and Referential Integerity with Cascade
Update.

Use three forms set as --
Project Form
Drawing Subform
Material Subform
 
Place the following declaration in a standard module.

Public Const CQuote = """" 'that's two quotes - used in string and
Where clause formation


Then place a copy of the below line of code in the After_Update event
routine for each textbox whose value you wish to carry forward.

Me!Name.DefaultValue = CQuote & Me!Name.Value & CQuote

HTH
 
larry,

thank you for the help. please bear with me, i am very new to this. how do i
add the declaration to a standard module?
 
karl,

thanks for the reply. i am going to try the suggestion from mr. daugherty
first, then yours, and finally mr. sheridan. the people on this forum are the
best.
 
ken,

you hit the nail on the head with your observation. we are currently using
an excel based form for recording the bom info, then saving each form
individually in a seperate file.

the templates are outstanding and i will attempt to adapt them if the
solution in post 2 and 1 do not work out.

thank you for the help!
 
A standard module is one that is not a class module - such as the
module for a form. If you already have modules showing in the
Database|Modules window then you can add the line in an appropriate
module. If you don't see any modules, click the New button and create
one and put your line of code in it.

HTH
 
Back
Top