Can't enter info into a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just smack me now because I know I probably shouldn't have done this, but it
was the quickest way I thought to create the what I needed....

I have a db set up where I enter:

Course date
Course number
Respondent number
Trainer name

and then use checkboxes (excellent, good, fair, poor) and blank areas (set
up for comments) to complete the form.

Here's where the smacking comes in....

I copied the tables, queries, reports and form (Respondent) and renamed the
copies (BannerRespondent). When I go to click on the button to enter my
info, nothing happens, not even an error message. Here's what I copied:

tblcourse
tblRespondent
qryRespondent
qryRespondentCourseTrainerDate
frmRespondent
rptRespondentCourseTrainerDate

Here is what I renamed my copies:

tblBannerRespondent
qryBannerRespondent
qryBannerRespondentCourseTrainerDate
frmBannerRespondent
rptBannerRespondentCourseTrainerDate

I'm still using tblcourse in addition to tblBannerRespondent.

What do I need to do to fix this?

Thanks!
Anita

P.S. Should I also add that when I went into 'Design' view on my query and
tried to make a 'one-to-many' relationship between tblcourse and
tblBannerRespondent it wouldn't work? How can I create it? Tks! :-)
 
Hi Anita,

Did you also change the data source (in properties) for each form / report
etc to the new table name?
 
As far as I can tell, yes I did.
--
Anita


SusanV said:
Hi Anita,

Did you also change the data source (in properties) for each form / report
etc to the new table name?
Click to expand...
 
If you see the name of the new tables in the form's Record Source property,
then you changed to the new tables. Does the code behind your command
buttons, etc. use the new names for the tables and other objects?
 
I had to change part of my code under 'Build Event'. I didn't even think of
that!

Is this what you meant?
 
If it worked it must have been what I meant <g>.
The details were unclear, but when you mentioned clicking a button to enter
info I assumed your form has a command button, and that the command button's
Click event causes a form to open or something. That Click event probably
included the name of an object from the old database, which would not have
changed when you renamed the forms and other objects.
In future posts a little more detail may help. A "button to enter info" is
vague, but "a command button to open the data-entry form" is much more
descriptive.
 
I'll remember that one. <g> I keep forgetting that it's called a command
button, but I now know I won't forget.

Thanks a bunch and have a great day!
 
Back
Top