Help with Forms and Listbox/Combo Box

[samcaunt]

Hi All,

Im a noobie to access, and have been tasked with creating a failry simple access database for my partner.

I have been trying to solve my problem for over 8 hours, trawling the web, youtube etc and just cant find what i need.

I have attached my Database, there are few issues:

1 - I get an error when loading up, and cannot for the life of me figure out where it is comming from.

2 - I have been trying to create a Listbox which will allow you to click on one of the returned results. On doing so i want the Main Page + Subform data to subsequently update.

The List Box is called List72 (This works as expected and provides the results)
The Subforms are called Telephone Conversations Subform + Text Conversation Subform

3 - Creating a Search button which allows me to enter the firstname and lastname of a Pupil and subsequently updates the Main Page with all corresponding details.

2 is most importent to me to get this working, I appreciate i have asked alot for my first post.

I also know very little above VBA so if possible doing anything outside of this would be helpfull to me...

Thanks to everyone that looks and helps in advance, you have no idea how appreciative i will be following getting any of the above sorted!!.

EDIT ************* If i am not asking the right question please let me know or you have any url links/youtube links where you can point me in the right direction where i can figure this out myself it would be much appreciated!. Thanks!. **************

EDIT *********** 14/09/2013 ********** I have updated my database slightly with some changes, but im still having the same issue with 2-3 above. The latest attachement is Sam999.zip.......... Many thanks ALL.

Regards
Sam

 

[missinglinq]

Only have time to address Question #1, the error On Loading the database:

If you go to Office Home Button - Access Options - Current Database and look at the Display Form Option, you have a Form named Student Details listed...but you have no Form named Student Details in your database!

My guess is that it is supposed to be the Form named Main Page, which is based on the Table named Student Details!

Linq ;0)>

 

[samcaunt]

Aha! thanks. Thank you so much for taking the time to look at it. Thats great. Now just to address the other 2 issues i have

I stayed up last night till 3am and i still cannot fathom this! haha.

Appreciate it!.

 

[samcaunt]

Ok looking further into this, i believe i might need to do something like this.. but just cannot get it working! .

Create an unbound combo box on my main form...

In the combo box's AfterUpdate event procedure requery the form with:

Me.Requery

Then in the Forms current event procedure, I need to do something like this:

Me.ComboName = Me.StudentID

Am i on the right track?......

 

[samcaunt]

Just so nobody wastes there time i got help from another site for the other 2 issues i have, a farily simple thing in the end. Cheers for looking all. Sam.

 

[spikepl]

FYI: If you post the same question on multiple sites, read this: http://www.excelguru.ca/content.php?184 and act accordingly, or end up in the doghouse

 

[samcaunt]

Wow!. I kinda feel daft for being honest.

 

[missinglinq]

Don't feel daft for being honest...Spike is just trying to be instructive! Letting us know that you'd found an answer was good!

Better still, when you find an answer yourself, or elsewhere, is to post that solution. That way, anyone coming along later, with a similar question, and searching this forum, can benefit from your solution. Then you become a contributor!

BTW, Welcome to the forum!

Linq ;0)>

 

[samcaunt]

For others this is the code in the unbound combo box on the Afterupdate which did the trick for getting my combo box to work!.

Private Sub List72_AfterUpdate()
Dim rs As DAO.Recordset

Set rs = Me.RecordsetClone
rs.FindFirst "[student id] = " & Me.List72.Value

If Not rs.NoMatch Then
Me.Bookmark = rs.Bookmark
End If
rs.Close
Set rs = Nothing
End Sub