sorry for my bad explanation.
Basically I've got a list box in the main form. When I click the item in the list box, I want to select that record in the main form.
Main form is called frmComponentLibrary
The list box is called List8
Thanks for your help and advice, I've now created a list box instead of a subform.
so what now? I have tried this, is this right? (i know its not cause it doesnt work)
Private Sub List8_GotFocus()
Me.RecordsetClone.FindFirst "[ComponentID] = & Me![List8]
Me.Bookmark =...
I have a form with 2 subforms in it. The first subform is from a linked table that has details about the record selected in the main form. The second subform is a list of all records in the mainform. (it is the same table as the main form). I am using this like a phone directory selector. I...
Ok, so I can use the macro builder to make a button open another form, or report, but....
How do I open an attachment that is in a table. The attachment is a pdf, .docx or .xlsx file.
I've only been using access for a few weeks now. I'm stuck on something that is probably quite simple.
I have a table that has the following fields:
OperativeIDCode
FirstName
LastName
Then I have tables for, Address, Tax Info, Traning. etc.
I know that all the details could be put in one...
Thanks Rookie,
I have make that tables and linked them as you suggested. Ill now attempt to make a form for entry and a report to go with it.... hmm.
By the way: great formatting, makes life easy!
I sorry if this is to simple for this forum. Please don't think im lazy either for asking, I've been trying all week to do this but can't make it work...
Im trying to make an attendence register as follows:
Date Location Attendee Topic Supervisor
The idea is 12 times a year over 9 or so...