Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George - 09 Feb 2005 02:17 GMT

On my form you enter one row of infomation - ie
Date - "Employee Name" ( Selected from Combo Box ) Tool Received - Etc. When
you get to the end of the row it creates a new blank row under it. What I
would like is for the name that was selected in the combo box in the first
row to auto fill the next's row's "Employee Name" - I would manually change
when required. Is this possible ?

Thanks

Reply to this Message

Sprinks - 09 Feb 2005 14:09 GMT

Hi, George.

Yes, use the combo box' AfterUpdate event to change the DefaultValue property:

Me![MyComboBox].DefaultValue = Me![MyComboBox]

Hope that helps.
Sprinks

> On my form you enter one row of infomation - ie
> Date - "Employee Name" ( Selected from Combo Box ) Tool Received - Etc. When
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

George - 09 Feb 2005 15:33 GMT

That works it copies the employee's number into the next row as needed but it
chops off any leading zero's in their employee number ie 00940 converts to 940
How can I fix ?

Thanks

> Hi, George.
>
[quoted text clipped - 13 lines]
> >
> > Thanks

Reply to this Message

Sprinks - 09 Feb 2005 17:37 GMT

Hi, George.

There goes Access assuming types again...usually a good thing. Explicitly
type the value by concatenating with quotes leading and trailing:

Me![MyComboBox].DefaultValue = "'" & Me![MyComboBox] & "'"

Each one is DoubleQuote SingleQuote DoubleQuote

Hope that helps.
Sprinks

> That works it copies the employee's number into the next row as needed but it
> chops off any leading zero's in their employee number ie 00940 converts to 940
[quoted text clipped - 19 lines]
> > >
> > > Thanks

Reply to this Message

George - 09 Feb 2005 19:59 GMT

Thanks - I would have never figured that out....

> Hi, George.
>
[quoted text clipped - 31 lines]
> > > >
> > > > Thanks

Reply to this Message