Search results

I'm sorry it's just Auto the GP came there by mistake

here it is: SELECT STUDENT.Auto, STUDENT.MOI FROM STUDENT;

The NotInList event is working perfectly, because I've been able to add an ID which is not in list, but I think the problem is with the AfterUpdate event. When I try to choose an ID (which is already in the list) I get the following message (Could not Locate) Here is my AfterUpdate code...

I tried it, it doesn't work. I even tried another work around solution, I've created a simple student form with a combo box (the option appeard) and then pasted it on the tab. but for some reason the combo box becomes inactive on the tab (when i choose an ID the related information does not appear)

ok, I'll explain. my form has a query behind it which consist of three tables related to each other. (Parent Information, School Information and Student Information) I have 3 tabs in my form, Parent information are in the first tab, scool information in the second tab and student information in...

Hi, It's me again! :confused: The combo box worked perfectly with the code you gave. However I tried the same thing on a form that has multiple tabs, but it didn't work. Here's what I did: I have a form that has multiple tabs. In the last tab (which contains student information: Auto, MOI...

Rural you are a genius !!!!! Thanks alot! IT WORKED! :)

here it is Private Sub Combo12_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[MOI] = " & Str(Nz(Me![Combo12], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub

I'm sorry I need one more thing regarding this topic. whenever I enter a new ID it asks me whether I want to add it to the combo list and if I say yes the student_info form opens and i get to enter the name. When I go back to the first form the name should be displayed automatically (since I...

I tried this but it didn't work, however I tried DLookup("[MOI]", "student", "[MOI]=" & CSng(NewData)) and it worked. Thanks

OK here is what I have: Table Name: Student Fields: Auto (Primary Key) MOI (number) Name (Text) I have 2 forms: 1) Student ,which contains student info I have created a combo box in this form for MOI, so whenever I type an MOI ID that have been previously entered I get the...

Hi Guys, I've been able to retrive the information if it was previously entered before using combobox as you suggested (THANKS!) However when I'm entering a new ID the combobox doesn't allow it. I have read that I can do that using the NotInList event and I found a code for it. but it's...

I have a PersonInfo with the following field: ID (Primary), Name (Text), DateOfBirth (Date), Address (Text) and I have created a form comtaining the above field. now I want the Name, DateOfBirth, Address field to be automatically populated whenever I type in an ID that have been entered...

I'm sorry but I'm very beginner at this. So can explain how to do it exactly?

Hi All! I'm working on a Personal Information Database. I want my system to do the following whenever I enter a person's ID: If the ID is already entered before, I want all the personal info fields to be populated with the person's details. If the ID is not entered, then I will enter...

Dear RV, Thanks for the hint. I found the solution!

Hi Guys! I'm working on this database in which I have 2 forms: one form has personal information (PersonalInfo) and the other one is a search form (Search) In the search form I have a field in which I want to type any part of the Name field in PersonalInfo form and I want to retrieve all the...

The names are not the same, below is the link of the code I used: http://support.microsoft.com/?kbid=210586

What do you mean by "value in the Name property on the Other tab is not the name of a field in the RecordSource"

I did exactly what you said, the problem is the code works perfectly in Visual Basic, but it fails to be called from the form field. I wrote in the field's Control Source =English([Amount_in_Numbers]) yet all I get is "#Name?" what could be the reason?