Search results

enriquephoenix, Here is your sample back, with combo working.

Glad to help.

Have a look at my attached sample. When you open the frmView you will see that DataID has either white or red background (White if check box is "Yes" and Red if "No"). Open this form in design view select DataID, then select Conditional Formatting from the Format menu, this will show you how...

Have a look at my attached sample. If I may suggest something, I would not use Hospital No:, you could use Hospital No but leave off the : I don't like spaces much either so I would have HospitalNumber.

I opened and closed it several times and each time moving through the records.Sorry to tell you, it worked fine.

Glad to help.

Sorry, here is is.

Here is your first example back, I have corrected a few "errors". You will notice that the combo for Titles has been removed from the order form. You will also see that I have added a form for you to add customers to Have a close look at the queries that are the sources for the forms and...

No you haven't, have another look at how my example works. Also have a look at the orders and orders details forms and their sources from the Northwind database.

In my case Guilty, I did not notice the date of the original post.

DES, Could you post a copy here?

If each time you create an Order you have to input the customer details manually then you table structure is incorrect. Have a look at my sample I posted here it is called "Combo to fill in controls". This should give you some ideas, you will notice that 1 Customer can have many records BUT the...

Just so I understand your question; You have a form frmInventory with a data source table inventory. Your have a form frmAuto_Quote with a data source table inventory. and you want to open the form frmAuto_Quote to display the same record that the frmInventory was displaying. I have not added...

Put this at the beginning of your code, which is behind your command button; DoCmd.RunCommand acCmdSaveRecord

Your attached db is now working with the flashing lables. The reason that Me.LoneWorkerCaution didn't work was that was NOT the name of your check box Me.LoneWorkerCaution? was its name I have changed the check box name and the label name. Couple of things (if you don't mind) I would never...

Post a copy of your db, so that someone can have a look at your problem.

You would export the query or table that is the source for the form, not the form.

I have never used this, however here is the <<Link>> You can also download a db with sample forms - it has "Line numbers in sub form" example>> Here <<

This is what you need; On your form put an unbound text box and call it txtNextServiceDate. Then put this code in your form. Private Sub CusServiceDate_AfterUpdate() Me.txtNextServiceDate = DateAdd("yyyy", 1, [CusServiceDate]) End Sub Private Sub Form_Current() Me.txtNextServiceDate =...

Here is a sample for you to have a look at. You should never display this (the Auto Number Primary key) to the user. You will note that I have used an automnumber for the doors table and also used a number field to give each door a number this could also be text (e.g D1 D2 etc). Hope this helps.