Recent content by nikki_k_85

Oh yes.. stupid me.. I used that the other day :o

I want to be able to choose a record from the combo box and then the rest of the fields fill in themselves... Also some of the fields are in a subform but are all linked to the entry in the combo box... can someone help me ? :confused:

use the syntax: msgbox("This Client Doesn't Exist - Please Try Again")

I have alot of different "WPS Number"'s and I want to hyperlink them to a PDF file for that certain number and be able to view it in a report I have. How can you do this? or is it possible?!

I have a combo box that deletes records, but when they are deleted "#delete" comes in its place. How do I requery it and update the combo box so only the ones that aren't deleteed are shown.

And also how can I get rid of the '#deleted' that appears in the combo when i delete a record

I got it.. I had it bound to the table.. instead i bound it to a query and it works... thanks for your help... any questions i have i know where to go!!!! ;)

yup already checked it

i fixed the problem where i can click... it had to do with coming from the switchboard to the form... it needed to be in edit mode :) but still no error... cant click other entries in the combo box

well as of now... there is no error... i just can't click on the records in the combo box to delete them... but it does delete when i can click on them i press the button to delete it and only my msgbox saying "WPS deleted" comes up. The record does not delete :confused:

its bound to the table

Here is the code... Private Sub Command4_Click() On Error GoTo Err_Command4_Click DoCmd.RunCommand acCmdDeleteRecord MsgBox ("WPS Deleted") Exit_Command4_Click: Exit Sub Err_Command4_Click: MsgBox Err.Description Resume Exit_Command4_Click End Sub And I have...

Here you go.. I fixed it up using a combo box for yes and no.. let me know what you think

Okay, I want to make a form with a combo box that you can choose a record and click a button to delete it. As of now I have the records in the combo box but when i can choose a record... i can't delete. and when i cant choose a record.. i can delete. Can anyone help me???? :confused: