Search results

You didn't say which version you're using, but Jeff Conrad's site is a good place to start. Jeff is on the Access team at Microsoft. There's also a book list at Luke Chung's site (FMS Inc). Unfortunately, this forum will not allow me to post links, so you'll have to decipher the following...

>>i cant use somthing that i dont know what it is or what it does i dont know SQL yet.... Well, you're supposed to be learning, so learn. If you don't know something, look up Help, start Googling, or actually read a book. We're more than happy to help you, but you have to put in 'some'...

OK, if you want to enter a clinet ID into a textbox and have that display the apprpriate record, then add something like the following to the textbox's AfterUpdate event: 'Code start Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "clinetid = " & Me!lstMyTextbox If Not...

To display the list in the listbox, enter the correct SQL statement in the listbox's RowSource property (to retrieve the data from its table). To display the selected record on the form when you select an item from the list, add code to the listbox's AfterUpdate event. Something like this: Dim...