Complex Coding --> Please Help

[JFo]

frmSites needs a query to include "State" as part of your Record Source. Think I am getting you and this is now done I think

The Control State should be a Text Box not a Combo Box. Done

Site Name is not required in the sub Form. My mistake that was dumb... site is already chosen it is the clients for the site I am trying to show, edit, add

Going back to States. You need a Form to add Cites and their State. This can be called when a new City is not on the list.

Think this is done as well, States list needs an element not to allow duplicates

Hopefully, I am getting your technique now

Sorry didn't get a chance to clean database yet

The only thing I think I have not got right this time is the not in list (the other things I did pretty much straight away and spent the whole time on this but keep getting the item is not in list error message)

Thanks



Attachment 4884

[Rainlover]

The only thing I think I have not got right this time is the not in list

Where and when do you get this error.

Bed time for me. TTFN.

[JFo]

Thanks Rain have a good night, thanks for everything

I will have a play anyway happens when adding a City to list CityID control in frmSites but won't let me change limit to list property. Opens form but is an error

Cheers again

[Rainlover]

I am getting too many errors.

Time to clean up your code before going any further.

PS I am glad to see you doing things properly. Or should I say my way.

[JFo]

I will create the new database this morning and will post soon

Thanks

[Rainlover]

I maybe jumping ahead a little here.

Please correct me if I am wrong.

The reason why you want the last result of your inspections is that some data is teadious to enter. Like Numbers Date of Contract etc. (Guess work here at examples.) These things always stay the same, do they not. So you do not want to reenter this type of thing.

[JFo]

Here is a minimal, cleaned version. I have obviously saved all my old tables and versions as we progress to them I will import more tables and re-use some code, etc

Same Not In List Problem stands, however everything else seems to work at first test

Attachment 4893

Thanks

[Rainlover]

I need 2003. Please

[JFo]

The reason why you want the last result of your inspections is that some data is tedious to enter. Like Numbers Date of Contract etc. (Guess work here at examples.) These things always stay the same, do they not. So you do not want to reenter this type of thing.

You are correct to a certain extent yes there will be some data that will remain the same that you discuss, however that is not the main reason

Say for example an equipment/ inspection has 150 questions and 5 of those are non-compliant (there is a problem). If the default value is displayed for the 5 questions then the inspector knows he has to check these (I may make these red). For the remaining 145 questions for this example let's say 140 remain the same for this next inspection. If these questions are displayed the user just needs to glance to check they are same however more than likely will have the last inspection report so will take no action at all
and simply change the other 5 questions. Therefore instead of having to do something 150 times you only need to do 10 things

Thanks

[JFo]

I need 2003. Please

Sorry

Attachment 4894

[Rainlover]

The following line is not required.

' stLinkCriteria = "Me![CityName]=" & Forms![frmSites]![cboCity]

See Attached.

[Rainlover]

You should now have enough information to create MOST of your forms.

Go for it.

[JFo]

The following line is not required.

' stLinkCriteria = "Me![CityName]=" & Forms![frmSites]![cboCity]

See Attached.

How else do you pass the new city name to the new form? --> I had it working that way at the very start however I was trying to pass the value that is typed in combo

Maybe it is not possible as the value is not ever recorded and is not in list hence my error messages and wasted time

Thanks

[JFo]

You should now have enough information to create MOST of your forms.

Go for it.

OK I will give it a go, however it is only the Inspection/Equipment/Checklist subform group that seemed to have ever caused me any trouble from my perspective tbh

Thanks

[Rainlover]

How else do you pass the new city name to the new form? --> I had it working that way at the very start however I was trying to pass the value that is typed in combo

Ask again in a new thread.

Someone will have an answer.