How to add Row Source to Label in Form

[SachAccess]

Hi,
I am trying to edit an existing form. This Form has multiple labels.

In Form view, in one of the labels, am getting a drop-down option to select the value.
Selected value is correctly updated in the respective table.

I am trying to add exact same feature to another existing label from the same form.
This label is free text. I am trying to change to drop-down options.

I tried editing this label. But am not getting option for Row Source and Row Source Type in the properties of this label.
The label which has drop-down option in-build has both Row Source in and Row Source Type in the properties.
Cannot see the same options for the label am trying to edit.
How do add Row Source in and Row Source Type in the existing label.
Can anyone please help me in this. Thanks.

 

[bob fitz]

You talk about labels, but I think you are talking about Textboxes and Combo boxes. You can only type text into a label when in design mode and only combo boxes can "drop down".
Perhaps you just need to delete the textbox and create a combo box using the wizard.

 

[SachAccess]

You talk about labels, but I think you are talking about Textboxes and Combo boxes. You can only type text into a label when in design mode and only combo boxes can "drop down".
Perhaps you just need to delete the textbox and create a combo box using the wizard.

Thanks a lot for the help.
Am checking and will revert with details.
Have a nice day ahead.

 

[SachAccess]

Hi,

I am facing on issue regarding this.
There is an existing working combo box in the form.
Drop-down is working on this CB.
This CB is linked to different table.

I just copied this CB in the form from design view, edited it, gave reference of the correct table.
However in this CB, am not gettting any drop-down options.
I can select the drop-down, but there not any values to select.

Strangely, I can see blank options in drop-down, which can be selected but no values are there.
I checked properties from working CB and tried replicating same in new CB with different table name but it is not working.
Can anyone please help me in this.

Below are the options selected in the properties of CB.

Data - Control Source - BusinessArea (field name from the table)
RowSource - Table name is correct, just copied and pasted from the table itself
Row Source Type - Table/Query
Bound Column - 1, there is only one column in the table

My apologies for not posting screenshot. Not allowed to.

 

[Minty]

Open the rowsource using the ....
It will give you the chance to create a query on the table (which you should do)

In the query designer open the datasheet view - what do you get?

 

[Pat Hartman]

What is the RowSource of the combo? When you paste it into the QBE, does it return rows?

 

[SachAccess]

Hi @Minty and @Pat Hartman thanks for the help.
I missed the notification last night hence delay in response.

@Pat Hartman RowSource is Tbl_Business_Area.
Sorry, I did not understand this. I tried below query. And it returns the entire table, however I guess you meant something else
select * from Tbl_Business_Area

PS @Minty I have tried to attach few screenshots. Could you please check if you get time.
From screenshot number 5, am trying this 'In the query designer open the datasheet view - what do you get?'.

 

[Minty]

Your column width for column 1 is set to 0, but you only have one column.
See picture 1. Column Widths.

 

[Pat Hartman]

Please tell us in words what you want to do with the data you are trying to copy to the clipboard.

We still don't understand why you want to copy the listbox's RowSource rather than its ControlSource. To copy the controlSource, you just reference it using the control name.

If we are dealing with a multi-value field that is a whole different problem so we need to know that.

 

[SachAccess]

Hi @Pat Hartman and @Minty thanks a lot for the help.
Somehow am not getting notifications for this thread. I tried checking the notification over weekend too but was not able to see.
This is why am missing to respond on time. My apologies.

Today I was able to resolve it copying method from below URL. I thought of replying to thread with this update and saw your replies.
Access 2016: Add a Combo Box to a Form (quackit.com)
This method is working perfectly for me.
Have a nice day ahead.

 

[Pat Hartman]

It is always easier for us to help you when you answer the questions we ask. At least you found a solution.

 

[SachAccess]

Hi @Pat Hartman , I agree. I guess I made it confusing for (both of) you to help me.
Going forward I will take utmost care to give required details and explain the problem statement in correct manner.
I understand, it is more irritating than trying to help on the actual problem with in-complete information.
Have a nice day ahead.

 

[Pat Hartman]

It isn't always necessary to know the purpose of what you are doing for me to solve a technical problem but in this case, you are doing something that is very likely to be sub-optimum. Copy/Paste isn't how databases work but to offer a rational solution, I needed to know where the copied data was going so I could offer an alternative to the paste and that would eliminate the problem with the copy. Anyway, we move on. You have a nice day too