Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi, George.

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

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

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

Sprinks said:
Hi, George.

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

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

Hope that helps.
Sprinks

George said:
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
Click to expand...
Click to expand...
 
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

George said:
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

Sprinks said:
Hi, George.

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

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

Hope that helps.
Sprinks

George said:
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
Click to expand...
Click to expand...
Click to expand...
 
Thanks - I would have never figured that out....

Sprinks said:
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

George said:
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

Sprinks said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top