Edit Command Button Trying to Link form

[TheViruz30]

See Attached Database

I created a form called cptSearch
On that form has a list box

What i want to do is when user clicks on cpt in list box and clicks on the edit command button it will open the frm called frmcpt so user can edit details for the specific cpt code


Any Ideas

 

[ansentry]

Have a look at your sample now, click your choice in the search field and the other form will open to that record.

In the form frmCpt I have also put a search combo (CptCode1) you can use this to find a record in the form.

You did not have a primary key defined (I made it CptID).

 

[TheViruz30]

Thanks just what i wanted but i changed the click event to the command button and enterd the stg link critera

works perfectly now

thanks again