command buttons with hyperlink to form

Hi,

I have a form which is used to enter in client details.

I have created a command button for the purpose of adding a new client.
I have placed a hyperlink on this button so that when I click on it it opens up a new client form where I can add in new client details name, last name etc.

My problem is that after I've entered in the client details and close the form, I go back to my main form window, and when I click on the client drop down list the client I just added isn't there.

I have been wrecking my brain with this...

I have tried making a macro....going into the properties, on click=[data entry], event procedures but obviously doing something wrong.

My access knowledge is intermediate and I am re-designing a database that someone else created and unfortunately that person doesnt work here anymore.

your help is much appreciated.

Thanks
stats09

Originally Posted by alansidman

Are you sure that the new client form you open is bound to the Client Table? Check your form properties and see if it has a record source as the client table.

Alan

in the record source (form properties) for the client form I put in................. SELECT tbClient.* FROM tbClient;

All the enteries say unbound.....eg title, first name, last name, the entry for this says unbound.

still doesntt work.....any ideas.


Thanks in advance!~~~

I have now solved this thanks