Query can not be used as a row source

[moke123]

You can randomize it. https://www.access-programmers.co.uk...5/post-1640309

[yrstruly]

No change at all

[madpiet]

Split your database and post the front end. I'm not interested in your data. Oh, and go back and import the table that's providing the values for the form's combobox.

[yrstruly]

The front end contains data, how do i get rid of it?

[madpiet]

If it's one database and not two (front end usually ends in _fe and the backend with _be (I think). if you didn't split it, and you go into the tables part, split databases will have an arrow... if you go into Tables, and click on Linked Table Manager, the linked ones will show up there.

[June7]

So what field type is FumigationStatus?

My suggestion works for me with a Yes/No field.

You can make a new database and import forms.

Or make a copy and delete tables or DELETE records or change data so it isn't real.

To attach file, follow instructions at bottom of my post.

[yrstruly]

Here is the BE and FE without data. Sample data for the two tables is in excell format. Form is frmtblPermitinformation
https://drive.google.com/file/d/1I5F...ew?usp=sharing

[madpiet]

those are COLUMN WIDTHS.

[June7]

Should always Compact & Repair before uploading files. Both files significantly reduced in size after C&R. Could have zipped and attached here to post. Should run C&R periodically.

Since you have RowSource of Yes;No, ColumnCount should be 1 and ColumnWidths can be blank.

[yrstruly]

Can you please amend the FE and share it with me, because im not getting anywhere with this. Same issue.

[jojowhite]

what is the form name with your combo?

[yrstruly]

"frmtbiPermitInformation"

[jojowhite]

on Design view, click FumigationStatus combobox and on Property Sheet->Data

Row Source: -1; "Yes"; 0; "No"

[yrstruly]

Please share the FE with me, where you made the changes

[jojowhite]

you need to relink it again to your BackEnd.
https://1drv.ms/u/c/c5af92cc292c1bb3...3xj6A?e=cRmGAC