John,
I opened the form to a new record having the the ListID entered using code and then the user entered the HomeInfoID.
Connie
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> Do you not have the HomeInfoID to do the INSERT of both fields? How were you
> doing it when you used a form?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Wednesday, October 26, 2011 5:55 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Required fields when using CurrentDb.Execute INSERT
>
> I am going through my code trying to change instances where I was opening a form
> in order to create a new record to the better method of using the
> CurrentDb.Execute INSERT method.
>
> I have a table ListingsHomeInfo where I had ListID and HomeInfoID as required
> fields. Therefore when I entered the ListID using the CurrentDb.Execute method
> it was asking for the HomeInfoID. So I'm guessing that I need to not require
> HomeInfoID in the table but rather check to make sure that it is entered in the
> Form's BeforeUpdate event. Is this correct?
>
> Thanks!
> Connie
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar