Search results

Many thanks Fofa, but I went with SJ's solution, as this was how I was taught it at uni. Works great. Was just having a brain fade, as we all do when we've been coding for far too long lol :D Thanks again

Hi All, Anyone know how to format a combo box to select tomorrows date. I need say the next 7 days dates to be displayed as an option for selection. Regards, Scott

Use the navigation bars at the bottom to manually scroll through and find the record, or right click in the patient number field and use the sort, ie enter 12345 and that patients records will come up.

Not sure if this will work, just an idea. How about on the formopen action, assigning a value to one of your fields and then removing that value, ie making that field null again. This should get you the autonumber.

Private Sub Form_AfterUpdate() cmbCustName.Refresh End Sub That would probably do it. Although without seeing the code I can't be sure.

Hi Mute, You need an afterupdate on the scroll that updates the combobox value with whatever is in the relevant field.

Hiya, Have had a look at your sample and had the same problem. Try using a slightly oversized column width than you actually think. Ie, when column widths are 0cm;4cm;4cm, use a total column width of 8.01cm.

Mute, I think the problem could be that you've used the me.count or whatever on the parent form. This will only work as a text box in the subform. You should have a text box in the subform with an afterupdate function that copies it's value into a certain textbox on the parent form. If you...

Doesn't the subdatasheet have record navigation bars which will display the record number your on and how many records there are. Would this suffice?

Try changing your code as this: Private Sub Command39_Click() txtprescription = Combo28.Column(1) & "-" & Combo30.Column(1) End Sub