Search results

So sorry. I misread that. I am unable to help with listview.

Strange behavior is often a symptom of corruption. Perhaps delete the list box and recreate it or even replace the entire form. I'm sure a search of the forum would give much advice on corruption.

I don't think that is usual behavior. What code are you using to disable listbox? Can you post a copy of the db?

Asuming Assuming that SiegesNom holds the number of seats available before any bookings, you could: Change the Record Source of frmBooking to SELECT tblBooking.BookingID, tblBooking.PassengerID, tblBooking.BaggageNum, tblBooking.FlightID, tblAvion.SiegesNom, tblAvion.SiegesNom FROM tblAvion...

You will need some validation code in the forms before update event. Can you show us your table relationships, or post a copy of the db.

Welcome to the forum :)

I created a textbox, Named txt1 and set its Height, Width and Top properties, all to 0. Set its Locked property to Yes. In the Change event of TabCtl257: Me.txt1.SetFocus

You're welcome. Glad that I could help. Post back If you have any questions on the changes that I made.

Try the attached file.

Can you post a copy o your db

IMHO a good db starts with good table design. Yours is like a spreadsheet. It has only one table. I would urge you to read a little on Db design, relationships, and normalization. Take a look at the attached db. I think you will need further tables. I have entered only the first record in...

Perhaps try setting Error Trapping to "Break on All Errors" in an attempt to find any code that is causing an error. Alternatively, you could post a copy the db for us to examine.

Hello. Welcome to the forum :)

Why don't you use the table as the Record source of your form and bind the controls on the form to the fields of the table?

Google translates your original post to: Welcome to the forum. I'm sure you'll get some great advice from members here.

skeletons never go to a discotheque because .................. they have nobody to dance with 🤣🤣

I don't think it's a good idea to add your question to a post that was solved over 3 years ago. Why attach a text file? You could have written all of that here. Attaching a copy of your db would be far more useful. IMHO it might be better to start a new thread for your inquiry.

Perhaps: Me.TXTCASE.value = DCount("REC_ID", "QPENSIONER_NEW", "YR = '" & Forms!SERVICE_FORM!CYEAR & "' And MN = '" & Forms!SERVICE_FORM!CMONTH & "'")

Can you post a copy of the db with just a few fictitious records.

Have you looked at the templates that MS has to offer e.g. Access Asset Tracking template. See: https://support.microsoft.com/en-us/office/use-the-access-asset-tracking-template-6e99a32c-fbda-48a2-89b0-ef0d68b381ec