Recent content by lgw002

It's as raskew says, its not about the form, the form(s) dont hold any information, its the tables that hold the data that the forms use. Try expanding on your information or post what youve done so far and we may be able to assist a bit more

I had a similar problem where I wanted to get some data to populate a combobox off the last few entries. After some research Ive come to the conclusion that there is no reliable way of quering the data table to obtain the last (or last few) entries ( even with autonumbering!) Microsoft...

Thanks Sergeant. Thats given me a good pointer to the AddItem method, I might go down that route later on. However I'm still trying to investigate any way of explicitly referencing to the last few items. I'm having a look at the DLast function on the tableID primary key, getting the number, and...

Thanks BryanT. As to reverse order I found it within seconds after that. Slight case of Doh! ( smack forehead ), however as an Access nubie trying to learn and pull together Access, VBA and SQL all at once I'm gonna forgive myself that one. As to the 'last few entries', I see what you are...

Think you need to show your code or explain a bit further, however as a complete guess make sure that the combo boxes are not selecting multiple columns. ( Look in your rowsource paramater for very roughly SELECT table.tableID,table.tabledata FROM table ). It then may possably be be that you...

Works ok for me. Shows dropdown and then populates the two date boxes ok every time, however shows error when promotion button clicked ( presume this is a seperate problem or not coded fully yet ?) Have you tried another simplified form without fields in the the headers and footers and see if...

Nubie question ( first real database) I'm trying to populate a combo box with the last few entries of a record. I've been looking on SQL Queries and can see a way of using SELECT TOP on the recordset but querying/sorting the whole record every time seems a very clumsey way of doing it...