Recent content by maff811

@Pat Hartman and @Uncle Gizmo - I had a go at pulling out the checkboxes from the Recommendations table and put them into their own tables. I separated them into three distinct tables - Change, Jurisdiction and Tags - with each linked to the Jurisdiction table by the primary key. Does this look...

Hi everyone, thanks for the great feedback. I'll have to spend some time to read through this and understand it. @theDBguy - I did play around with your suggestion to use a listbox and got to the point of being able to select multiple statuses. I then started to read up on how to convert the...

Thanks theDBguy. The database is attached. If you go to the Navigation Form and then the REport tab, you'll see what I'm trying to do. For the time being, i have used the combobox to select a status, but it turns out having the ability to select multiple statuses is preferable.

Initially this: Expr1: [ResponseStatus]=IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![Implemented]=True,"Implemented","") As far as I can see, this should convert a checkbox for the status 'Implemented' that is selected to text that says 'Implemented'. I am then trying to get it...

Thanks theDBguy. The Yes/No fields are used for tags so that users can categorise text for further thematic analysis. I did try an IIF expression, but maybe I didn't get it quite right. I'll try again...

Hi all, I have two tables, let's say A and B. Table A contains a number of Yes/No fields while Table B has text fields that contain various statuses. Tables A and B are linked via the status field. I also have a form on which I have multiple checkboxes so that a user can select a which Yes/No...

OK, thanks for the advice. I'll look into those suggestions you have outlined.

I populate the subform based on unbound fields in the Main Form. The subform is an unbound form also. Does this assist? SELECT Expenses.ExpenseID, Expenses.DatePaid, ExpenseTypes.ExpenseType, Expenses.Description, Properties.Address, Properties.Suburb, Properties.State, Properties.Postcode...

Thanks theDBguy. I have seen these suggestions mentioned elsewhere. Before I explore those suggestions, can you tell if the code I have used is flawed?

Hello, I have been on several forums, but haven't quite yet managed to crack this one. I think I am also getting tied up because of the Navigation Form. What I am trying to do is export the data contained in an unbound subform that displays data based on parameters that a user has entered on...

Ahhh... I see, so with that, you are asking the query to show the first record, which is the 'dummy' record you have added. Is that right?

Hi arnelgp, your solution is the one that I prefer in terms of the desired output. I am having some trouble understanding the query that sits behind it though. I'll keep looking at yours and see if I can replicate it in my DB. Thanks to everyone else who offered suggestion.

Hi, did you ever find a solution to this? I am having the same issue.

Thanks Gasman. I'll check that link out.

Thanks Minty, I see your point. That would obviously be the more advanced way of coding it, as opposed to my beginner approach! I might have a play with that once I get the rest of it working and see how that goes.