Combo Box

[George]

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

 

[Sprinks]

Hi, George.

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

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

Hope that helps.
Sprinks

 

[George]

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.

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
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

 

[Sprinks]

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
How can I fix ?

Thanks

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
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

 

[George]

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

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
How can I fix ?

Thanks

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
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