Recent content by LindaLooUK

Bless you for posting an example database - it works a treat!! I really do appreciate all your efforts with this, thank you. :)

Many thanks for the reply but unfortunately this doesn't work either as it's still displaying the first record on FormC. There is a further subform on FormC (FormD) but that shouldn't affect the movement of records on the first subform should it. FormA FormB FormC (subform) FormD...

Hi everyone I really hope you can help as I've spent way too long on trying to solve this issue myself. :o :banghead: I'll try and be brief. FormA is making a call to FormC that is a subform of FormB. So, FormA is asking FormC to move to the next record and then provide the details of this...

Thanks for the reply Mark, it worked a treat. :)

I have a function that I'm using in an update query but it fails because of a null value. The purpose of the query is to insert the Invoice ID (InvID) into the field InvoiceRunID where InvoiceRunID is currently null (and the Status = 5). gInvDate is a global variable that is set before the...

Doh! I've just tried this again and it actually works fine without the need to go through hoops! I just pass the lngID (primary key) to the form that contains the listbox in the OpenArgs property and then use that value in the OnOpen event of the form: lstListbox = lngID The listbox is...

Many thanks for the kind offer, that would be really great if you don't mind. :)

Thanks for persisting with this Steve. However, the listbox I'm referring to does not have a row already selected as I don't know which row the record I'm interested in is located! I'm trying to get Access to select the row based on a specific unique value in column 1.

Many thanks for the prompt response Steve but I'm not sure how this helps me...sorry if I'm being completely dim here! ;) The column property allows you to specify a column and then (optionally) a row number but as I don't know which row the desired value appears in how would I specify this?

Hi folks First post here so I hope you'll be gentle with me! In plain English, I want to select an item in a listbox that has a specified value when I open the form that contains this listbox. Most of the help I've found describes selecting records based on their index value but I want to...