Code for form

's Computer Specifications

Hi,

I have copied this from a form I created earlier only I cant remember what
each item refers to as I cleavely named them all the same thing!!

Could someone look at this and let me know what they should be refering to
then I should be able to modify the code for my new form.
Thanks

For Each CDuration In ws.Range("CDuration")
With Me.CDuration
.AddItem CDuration.Value
.List(.ListCount - 1, 1) = CDuration.Offset(0, 1).Value
End With
Next CDuration

's Computer Specifications

Forget this post - I have started a new one with even more questions!

"Leanne" wrote:

> Hi,
>
> I have copied this from a form I created earlier only I cant remember what
> each item refers to as I cleavely named them all the same thing!!
>
> Could someone look at this and let me know what they should be refering to
> then I should be able to modify the code for my new form.
> Thanks
>
> For Each CDuration In ws.Range("CDuration")
> With Me.CDuration
> .AddItem CDuration.Value
> .List(.ListCount - 1, 1) = CDuration.Offset(0, 1).Value
> End With
> Next CDuration

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
code to open blank form activates code to show record has changed	Repent	Microsoft Access Forms	2	20th May 2009 05:24 PM
Child form code access to parent code object	=?Utf-8?B?UmF5IE1pdGNoZWxs?=	Microsoft C# .NET	1	1st May 2007 05:14 AM
how do I keep a form open but only process code after the form after a certain button on the form is clicked?	Keith G Hicks	Microsoft Access Form Coding	1	3rd Dec 2003 08:14 PM
Code Opens form when there is no Data ? See Code Below. Thanks, Dave	Dave Elliott	Microsoft Access Forms	1	1st Nov 2003 03:54 AM
How can I update all data in a form by typing a zip code in the zip code field	Kevin	Microsoft Access Forms	1	22nd Aug 2003 10:52 PM